Pulling data using In-database Data stream in without creating temporary table

Question

Hi,

I am very new to In-db tools. I've used python tool to pull data from the server and been trying to use In-database 'Data Stream In' tool to bring the data in but the problem is I don't have permission to create a temporary table, so it errors out.  Is there any other way the data can be pulled in without having to write in a temp table.

Any help is much appreciated.

Thank you!

2022-02-01_14-19-04.png

apathetichell · Answer

As I noted in my initial response to your question - you have two options:

1) query the data in a regular workflow - your data on server has to exit via datastream out or be brought in via  standard input data tool.

2) query the data in-db. Your python data must be given an address on your server so your server can use it. This is datastream in. Think about it. In order for your server to be able to use your data it has to be on your server. Temporary/regular table allow your sql platform to find the data.

rjbrsh · Answer

Hi @gabrielvilella, that makes sense but below is workflow I wanted to create. I was wondering if there was any other way I could pull the data in through in-database tool without having to write on a temporary table.

gabrielvilella · Answer

First you need the Connect In-DB or the Dynamic Input to get the data from the database. Then you use the Data Stream Out tool to pull data from the database. Finally, you can transform this data normally on your workflow.