222 questions
- Bountied 0
- Unanswered
- Frequent
- Score
- Trending
- Week
- Month
- Unanswered (my tags)
0
votes
1
answer
39
views
Capture Oracle metadata via Debezium connector
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 ...
0
votes
1
answer
316
views
How to properly initialize and query a PGVectorStore with metadata columns in LangChain?
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 ...
0
votes
0
answers
53
views
Unable to edit on multiple tables opened simultaneously on DBeaver, says couldn't find table metadata
When I select and launch multiple Select SQL queries on DBeaver, which open several tables simultaneously, I can no longer edit data on those table because DBeaver seems no longer able to find the ...
0
votes
1
answer
59
views
how to optimize this sql searching for metadata in Oracle
this is the sql
SELECT distinct a.owner,
a.table_name,
a.column_name,
a.data_type,
b.comments,
a.data_length,
...
3
votes
2
answers
245
views
How to Find index include list and filter definition of BTree index in PostGreSQL?
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 ...
2
votes
1
answer
1k
views
How to get the structure of SYS_NC columns (in an Oracle database) using a jdbc driver?
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 ...
0
votes
2
answers
460
views
Retrieve entities and other objects from a solution / solutioncomponents in order to delete them, using Dataverse client Sdk
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 ...
1
vote
1
answer
65
views
List Members of an Index in PostgreSQL
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(...
2
votes
1
answer
1k
views
How to make schema graph with sqlalchemy_schemadisplay?
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,
...
0
votes
0
answers
118
views
Where to find user-defined types in table catalogue views
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 ...
0
votes
1
answer
1k
views
Configuring oracle database as airflow metadata backend db does not create airflow tables when deployed from docker
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....
4
votes
1
answer
3k
views
How to show user schema in a Parquet file using DuckDB?
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 ...
0
votes
1
answer
597
views
Find the folder name and mapping name details impacted by particular target table in informatica
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 ...
0
votes
0
answers
1k
views
Wrong Oracle database and JDBC Driver version printed by Hibernate SettingsFactory
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 ...
0
votes
1
answer
145
views
Add metadata tag to teradata objects
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 ...