Change datatypes dynamically of every column
Hello everybody,
Need help creating a pipeline. The data am working on looks like below:
Header
Datatype
Data
Data
Data
This is a CSV file so every column comes as a string. I want...
Forum Discussion
Can I ask a question on top of this.
I output of my mapper has correct datatypes,
I placed a Snowflake Bulk Load snap after the mapper with below configuration
This snap should create a table in the database if it is not already existing.
Pipeline ran successfully and the table was also created.
But when I see the datatypes in my database, all the columns are Varchar
Is there any specific reason for this. How can I ensure that the datatypes at the end of mapper to reflect in my database(snowflake)?
Thanks,
Sunil
Hello,
Can anyone look into this please. Is this an issue with Snowflake snaps?
I used Snowflake Bulk Load snap many times before to upload data. Usually, I create necessary tables using DDL statements before hand in snowflake and then use Bulk Load snap in my pipelines, but this is the first time am using ‘Create table if not present’.
Thanks,
Sunil
