Currently I am trying to use SQLExecutor2 to a DSS Webapp. The reason why is that I have a large dataset and i want to get the data filtered.
First I was trying to use an existing Dataset that has been created in DSS Flow from SQL table like below.
mydataset = dataiku.Dataset("VALUE_TAB")
executor = SQLExecutor2(dataset=mydataset)
test_query = """SELECT * FROM VALUE_TAB WHERE VERSION = 'V3'"""
result = executor.query_to_df(test_query)
I had an error message that says that:
"Could not find table/view VALUE_TAB in schema SCHEMA".
Is there a way to use in a Webapp a dataset from DSS flow with SQLExecutor2 library , or i have to make the connection directly with the SQL?