Hi! I am new here, testing possibilities with data...
# ingestion
m
Hi! I am new here, testing possibilities with datahub. With ingestion and profiling, I have a problem. My recipe looks like this source: type: mssql The ingestion works, but I dont see any stats. But there is a bunch of error messages right before:
Copy code
"AttributeError: 'Insert' object has no attribute 'columns'\n"
'[2022-08-31 09:46:52,291] ERROR    {datahub.utilities.sqlalchemy_query_combiner:249} - Failed to execute query normally, using '
           'fallback: \n'
           'CREATE TABLE "#ge_temp_dbf5dfdd" (\n'
           '\tcondition INTEGER NOT NULL\n'
           ')\n'
           '\n'
I found this question in the history of Slack, but there is no answer there. Could you help me with this problem?🙏
h
Hi @mysterious-dress-35051, does the user have permissions to create tables? The great_expectations library that we use for profiling creates temporary tables when the
limit
config param is set. You can either not set this param or grant the user write privileges. Please share the profiling section of the config that you are using.
What profiling settings are you using?
h
Hey @victorious-evening-88418 ! Are you using "mssql" to connect to Sql Server ? What is the version of Sql Server?
glad to hear !! Thanks for sharing what worked for you . 🙂