A complete solution for open data platforms, enterprise data catalogs, data lakes and data management. Open source, mature, fully-featured and production ready.

DataHub

Hello team :slightly_smiling_face: Does anyone know what specific privileges are needed on schema level to ingest data from MySQL ? (more on thread)

First, i thought only select privileges on information_schema is needed, but it turns out i need privileges on the schemas that i want to ingest - which is a too much privilege in terms of security at my company.

At the same time i wonder - i think all the information that is needed for datahub can be extracted from information_schema.. but why does datahub need all the privileges on other schemas? :disappointed:

Hi <@U02EXJZ0KMM>,
A lot of the sql based sources use a common functionality which looks at individual tables to get the schema. For some sources like redshift, it is optimised. But I don't think it done for myself.  But thanks for calling it out.

<@U02AYK6RSPP> Oh i understand, thank you for the reply. :slightly_smiling_face: