Official

Accepted

Unanswered

Relevance
Selected Relevance

Advanced Filters

Search Results (14)

Extended Properties in Catalog Ingestion

In our SQL Server databases we have included table and column definitions as extended properties. Can I extract these extended properties and load them into Collibra using Collibra Catalog data ingestion?

Questions

59

2

0

REVIEWED-PENDING DOCUMENTATION: What is the work flow for a DQ Check Job, and how are rules applied, do rules hit the original data source?

Question: My understanding is that there are two possibilities for rules to run. One is they run against the Apache Spark Dataset created by the DQ Check, thereby they do not bother the customer datasource. The other option is that a DQ Native SQL rule is created which is targeting a native database

Questions

46

0

0

0

XML Datatype within SQL database

We are trying to onboard a SQL source to Collibra containing XML datatype. Has anyone had any experience /success with successfully doing this using the Collibra SQL JDB driver?

Questions

68

3

0

0

Can I include table/column descriptions in a Collibra Catalog data source?

When registering a Data Source in Catalog, can I include the table/column descriptions?

Questions

258

9

0

Harvest lineage from SQL files

Hi, I have a few local MSSQL & ORACLE DBs that can not be linked to Collibra’s Tech lineage harvester. However I have rights to run any kind of queries on these DBs. I want to harvest tech lineage from these local DBs and was wondering if there is a method to do that (may be by SQL Files). Colli

Questions

226

3

0

0

SQL Server Springboot integration

Hi @spring-team.collibra.com, i am trying to connect to SQL server, and would like to know, if you can help me with the Connection string for remote SQL server. Currently i am using the following: sql.datasource.jdbc-url=jdbc:sqlserver://;databaseName=;TrustServerCertificate=True sql.datasource.use

Questions

23

1

0

0

How can I configure BigQuery Technical Lineage "other query" when I am using INFORMATION_SCHEMA.JOBS instead of ROUTINES/PARAMETERS

hello, I am configuring a BigQuery Technical Lineage, but I have realized that in the section "other queries" the tables from information schema used is not the same from the default collibra query : SELECTr.routine_name,CONCAT('CREATE ', r.routine_type, ' `', r.routine_schema, '.', r.routine_name

Questions

14

1

0

Extracting KPI definitions from database views

Hello, In my organization there are several hundred KPIs defined in a views. (For example, there is CustomerKPI view select a * b / c as CustomerScore1 definition. Is there a way in Collibra to automatically extract those definitions for purposes of crating KPI catalog? If so, how? Do we need to cre

Questions

34

1

0

Ingest specific SQL tables from a schema

Hello, I am trying to ingest some tables from a schema from an SQL server. I only want to ingest a few tables and ignore the rest. I am trying to use the connection string given in the documentation - “Tables=TableA, TableB, TableC”. However, I only see the schema ingested and none of the mentioned

Questions

244

11

0

0

REVIEWED-PENDING DOCUMENTATION: Are JOIN statements allowed when creating a Dataset?

The question has repeatedly been asked by DQ customers, “Are JOIN statements allowed when creating an initial Dataset, in the scope query?” I have heard many different answers, so I asked Brian Mearns, the DQ Product Owner to clarify. He said : “When creating a DQ dataset, the DQ scope query will al

Questions

40

0

0

0

Rules details export shows difference with respect to summary details

Has anyone experienced a difficulty in interpreting the export of rules details in a data quality job.? The export shows much larger difference with respect to the summary details in a data quality job findings that uses a pushdown connection.

Questions

12

1

0

Collibra DQ unable to join dataset using @

For a specific dataset created, Collibra is not able to see it as a dataset name and is throwing error - Exception with freeform sql rule check: extraneous input '@' expecting ... Usually if @dataset is registered, the query will change the name of the dataset from @dataset to <dataset>_datas

Questions

14

0

0

TO BE REVIEWED: DQ Rule Creation: Simple vs. Freeform vs. Native

Customer Question: “Please advise if this type of rule can be written as a Simple Rule, or must it be written as Freeform SQL or as a Native SQL rule?: BP_HIGH_IND is NULL AND BP_IND IS NULL AND ADDR_LINE3_TX is NOT NULL AND (length(ADDR_Line1_TX) > 40 or ADDR_LINE3_TX NOT rlike (’^[a-zA-Z0-9,#&a

Questions

78

0

0

0

Cant connect Collibra to SQL Intanced Server

Hello, we are trying to connect Collibra to a instance in our SQL Server with the jdbc string: jdbc:sqlserver://{SERVER}\{INSTANCE}:{PORT};databaseName={DATABASE};encrypt=true;trustServerCertificate=true, but it keeps returning this error: Unexpected error running test connection Test jdbc connecti

Questions

36

1