Start Free Trial

Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.
SOLVED

Create tables in sandbox using Data Stream In

shihsw92
5 - Atom

Hello, 

 

I was exploring the usage of in-database tools more and was wondering if there are ability for me to utilize the Data Stream In tools to create/override tables to tables into a user sandbox, such as specifying the schemas and tables for me to write to. Our database server are microsoft sql server

 

Please let me know if I can provide more information!

 

Thanks!

John Wang

2 REPLIES 2
bharatandalam
8 - Asteroid

Hi @shihsw92 ,

 

You can overwrite/create a table by using the below: In the table name you can provide the DB.schema.tablename

 

image.png

shihsw92
5 - Atom

Thank you! I was having issues with creating temp tables and assumed I was going to have the same issue on using create tables. Thank you for your help! It works1

Labels
Top Solution Authors