Hello, I have multiple production environments wit...
# advice-metadata-modeling
w
Hello, I have multiple production environments with the same schema. How does Datahub distinguish between each of these distinct sets of metadata?
1
a
We currently have a concept of data platform instances here: https://datahubproject.io/docs/platform-instances/
Let me know if that helps explains things! There’s a schema at the bottom of that doc
You can a platform instance by setting this flag on your ingestion source -> platform_instance
w
Thank you, I will take a look.
I got this in thel ogs when running with a
platform_instance
set
Copy code
2022-12-01 09:52:23,336] WARNING  {py.warnings:109} - /tmp/datahub/ingest/venv-redshift-0.9.3/lib/python3.10/site-packages/datahub/utilities/sqlalchemy_query_combiner.py:326: SAWarning: SELECT statement has a cartesian product between FROM element(s) "xtzawitztbbgaejw", "puzlwittwrgomkab", "cmtiouylnmhuzemt", "fnwutwlgcqigqidk", "gxdstclfzfalhiey", "iaweijhnljxbvwpr", "jipautyjzqyseyyl", "drkynvfjxaasnvbo", "yrioudhwexcyiyjw", "gdcvxedkvsnkesep", "whipbyxplsubokec", "ztjommozakaknmgc", "pcqdgwusvfunkajd", "wsdakfksqwfnavcw", "tisjovpulgxquoib", "cbzhngnohomahadk", "kzkoebtlaueykubf", "zrqznaqdyucjbjib", "dzypqxwxshjqotio", "dhpfieejswejoisk", "fdztlcbjktvgionr", "mgfbaskeumftjrpl", "iajeiwcprykvnwvd", "txcsgtxxcyvqocjv", "dywjzwpzjyqoojfp", "hqcvuynlxkotifmz", "ygztjybkbnpbumnp", "lsilbbuekcbytzyp", "itnxpofeyvnjwjcu", "lcoomgtkdgmpgmkn", "bmkvsialqoftndfd", "lkswskvrthyrtaqw", "zhmmondrivvcwheh", "sfkmpywfkazwkrjo" and FROM element "iysrhljuoqnrbenm".  Apply join condition(s) between each element to resolve.
  sa_res = _sa_execute_underlying_method(queue_item.conn, combined_query)
a
Hi @witty-microphone-40893, this warning should actually be OK! Was it impacting the platform functionality?
w
OK, the ingestion worked for that source. I'll take note if it causes an issue with other ingestions. Thanks!