This website uses Cookies. Click Accept to agree to our website's cookie use as described in our Privacy Policy. Click Preferences to customize your cookie settings.
Accept
Reject
Preferences
FAQ
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 

Salesforce data types not coming over when loading SQL Server

fmdf
New Contributor III

‎07-22-2021 09:24 PM

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. Almost everything is coming over as varchar(8000).

I have read the documentation on this snap many times and it is not well written to explain how do I get the data types to come across and create the tables correctly.

Anyone have issues with this? Do I use XML/Json? Bulk API makes sense to use because I am loading a data warehouse.

I’m stuck.

0 Kudos
5 REPLIES 5

koryknick
Employee
Employee

‎07-26-2021 09:54 AM

@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.

0 Kudos