We have hundreds of tables to replicate to Snowflake as our destination, so it makes sense to have StreamSets autocreate these at the destination with the correct DDL but the functionality does not seem to be working. Besides checking the 'Table Auto Create' box are there any other steps we should take?
Solved
Autocreate Tables to Replicate to Snowflake Error
- Senior Community Builder at StreamSets
- 95 replies
Best answer by Drew Kreiger
You need to make sure the Data Drift Enabled box is checked and the Table Auto Create box is checked. The user also needs to have correct permissions in order to create tables in Snowflake. You can also check the Snowflake History from the Snowflake console to see the commands we issue to Snowflake and see if there is more information as to why the table is not created.
- Senior Community Builder at StreamSets
- 95 replies
- Answer
You need to make sure the Data Drift Enabled box is checked and the Table Auto Create box is checked. The user also needs to have correct permissions in order to create tables in Snowflake. You can also check the Snowflake History from the Snowflake console to see the commands we issue to Snowflake and see if there is more information as to why the table is not created.
Reply
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.