Information_schema.columns : identity information missing

MikeHubrecht — Wed, 12 Mar 2025 12:22:05 GMT

In the documentation is stated that the identity information is reserved for future use and currently always returns 'NO'.
when is this going to be available ?

and is there an alternative way to check if a specific column is already identity-defined or not ?

Re: Information_schema.columns : identity information missing

MikeHubrecht — Fri, 14 Mar 2025 11:24:19 GMT

found an alternative way to check it for the moment :

# check if identity column is active or not work around

identityValue = 0

try:

identityValue = str(spark.sql(f"show create table {table_catalog}.{table_schema}.{table_name}").collect()[0]).lower().index("identity")

print(f"No processing {table_catalog}.{table_schema}.{table_name} with primary key : {column_name} because there is already an identity column")

except:

identityValue = 0

print(f"Further processing {table_catalog}.{table_schema}.{table_name} with primary key : {column_name} because there is no identity column")

topic Re: Information_schema.columns : identity information missing in Data Governance

Information_schema.columns : identity information missing

Re: Information_schema.columns : identity information missing