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