I am using the command DESC EXTENDED with success, and casting it to JSON, for example: DESC EXTENDED mycad.mysch.mytab1 AS JSON; But I need this information for data-govenance of many tables, in ...

I'm sourcing Oracle data into Kafka topics using Debezium Oracle connector. I have a source Oracle table, as below: CREATE TABLE MYDATA.MY_USER ( USER_ID RAW(16) DEFAULT SYS_GUID() NOT ...

I'm trying to use PGVectorStore in LangChain with metadata columns, following the example in pypi page, but I'm encountering issues when attempting to add and query documents with metadata. The basic ...

this is the sql SELECT distinct a.owner, a.table_name, a.column_name, a.data_type, b.comments, a.data_length, ...

I have to create a complete view of BTree index list to analyze the performances of each and to flush out abnormal indexes (includes or equivalent) to drop them... Nevertheless I cannot find a way to ...

I've developed an application to analyze differences between 2 database tables (e.g., when migrating from DB2 to Oracle) - through JDBC connections - and I have a test case that I don't know how to ...

I need to delete all objects in a solution (ideally in a batch). I have already found several ways to get all their IDs by retrieving the solutioncomponent table. But it seems that to delete them I ...

I've search here in StackOverflow and other sites, but I'm still not able to list the members of an index. The simplified case is: CREATE TABLE employee ( id INT PRIMARY KEY NOT NULL, name VARCHAR(...

How to make schema graph? meta = MetaData() meta.reflect(bind=engine, views=True, resolve_fks=False) graph = create_schema_graph( metadata=meta, show_indexes=False, concentrate=False, ...

Of sys.objects BL says "Contains a row for each user-defined, schema-scoped object that is created within a database" The following shows the creation of 2 schema scoped objects, a table and ...

I am running a proof of concept to connect airflow and oracle database to store airflow metadata. From the documentation (https://airflow.apache.org/docs/apache-airflow/stable/howto/set-up-database....

I am trying to use DuckDB to show the user-created schema that I have written into a Parquet file. I can demonstrate in Python (using the code example at Get schema of parquet file in Python) that ...

I need to find the informatica objects dependent on one table. Please help me with the metadata sql query to get the folder name detail and mapping name which are impacted by this specific target ...

Our Java program has been installed on the RHEL 8.5 OS platform. And for database operations in our application, we use hibernate (version hibernate-3.2.7.ga.jar). Additionally, we are utilizing the ...

I have several stored procedures in Teradata that I wish to label. Therefore, I'm looking for a way to add metadata to an object in Teradata. I've been looking into Teradata's Data Dictionary, but it ...