Forum Discussion

fmdf's avatar
fmdf
New Contributor III
5 years ago

Salesforce data types not coming over when loading SQL Server

I am grabbing an object in Salesforce using the Salesforce Read Snap. I am using SQL Bulk Load and it is flagged to create table if it doesn’t exist. My numeric types are not being created in SQL...
salesforce
koryknick's avatar
koryknick
Employee
5 years ago

@fmdf - the “Create table if not present” option is s convenience feature for developers to get started quickly. I would not recommend using this feature for a production pipeline.

You are correct that the “Match data type” feature only applies under specific criteria. I will mention to our documentation team that they should try to improve the clarity and ask the dev team if it would be possible to disable or hide the option when other settings make it irrelevant.