I am trying to import prestosql(340) metadata and ...
# ingestion
s
I am trying to import prestosql(340) metadata and faced error message TrinoUserError: TrinoUserError(type=USER_ERROR, name=MISSING_CATALOG_NAME, message="line 26 Catalog must be specified when session catalog is not set", Below is my config: [6:09 PM] source: type: sqlalchemy config: platform: trino connect_uri: trino://xxx:xxx@xxxxx:8443/hive/xxx options: connect_args: catalog: hive schema: xxxx verify: False domain: "urnlidomain:xxxx": allow: - ".*" sink: type: datahub-rest config: server: 'http://xxxxx:8080' (edited)
d
Catalog should be set at the
database
property -> https://datahubproject.io/docs/metadata-ingestion/source_docs/trino/
s
@dazzling-judge-80093 Database is also not working
Any one have one config sample for ingestion from prestosql by sqlalchemy?
d
Here is a sample one:
Copy code
source:
  type: postgres
  config:
     host_port: localhost:5432
     database: postgres

     # Credentials
     username: myusername
     password: mypassword


# see <https://datahubproject.io/docs/metadata-ingestion/sink_docs/datahub> for complete documentation
sink:
  type: "datahub-rest"
  config:
    server: "<http://localhost:8080>"
Why did you use the Trino source for Postgres?
s
@dazzling-judge-80093 Thanks for your replay, I mean prestosql not Postgres.
d
ahh, sorry, my bad, currently we use the Trino driver and I’m not sure if it works with Presto as well
What error message do you get?
s
TrinoUserError: TrinoUserError(type=USER_ERROR, name=MISSING_CATALOG_NAME, message="line 26 Catalog must be specified when session catalog is not set",
is there anything wrong with my configuration?
If trino driver is not working is there any other solution for prestosql (340 is the version)
I am fix it by using presto dialects.
d
That should work and we should provide a presto source which uses the Presto driver as the trino driver does not work with Presto unfortunately :(