How is it work, if it is connected Data Base?

[417faa56b9e53ff7ff81]

I guess I can create a recepi with loading the part of data from database, but I am not sure, where to excute it. Perhaps, I can export to script, and I can excute it at Database side?

[TrifactaUsers · Accepted solution]

Hi,

Once your recipe is ready, click "Run" job

If you would like to execute the job and store the result into a table, then follow below steps:

1. run job
2. Add Publish action
3. If, its database, select the appropriate database you have access to
4. If the table doesn't exist, click on create new table,then click ok
5. select "run job"
6.  

[417faa56b9e53ff7ff81]

Thank you for your answer immidiately!

I got how I can excute it with this process.

So it means that I don't need to export to script and that is not work at Database side right ?

[TrifactaUsers]

It is not required. but if you have a external framework for job execution, then you might have to download the .cli scripts and pass it to the framework for execution.

[417faa56b9e53ff7ff81]

Thank you for your replying.

?

I undrestand. I really appreciate that you answerd in detail !

[TrifactaUsers]

Please mark it as the "answered" which is just below your question thread.

[40019bedddae3e6f8552]

Hi,

I'm still new to Trifacta. I want to connect to database table(Azure SQL Database) and run the recipe against it.

Is the Job a scheduled job?

I want to export the recipe output to a database table. Does the output including the valid/Invalid records?

thanx