2021.10
Collibra DIC Integration
Powered By GitBook
DQ Job MySql

Video Tutorial (MySQL)

Add automatic data quality to any database in 60 seconds. This example shows a single table being selected for DQ, however Owl also provides the ability to scan all schemas and tables at once.
Connect to any database using JDBC. Mysql example below.
1
-q "select * from lake.stock_eod where date = '2017-01-20' " \
2
-u username -p password \
3
-c "jdbc:mysql://owldatalake.chzid9w0hpyi.us-east-1.rds.amazonaws.com:3306" \
4
-rd "2017-01-20" \
5
-dc "date" \
6
-ds "stocks" \
7
-driver com.mysql.jdbc.Driver \
8
-lib "/home/ec2-user/owl/drivers/mysql/"
Copied!
Last modified 1yr ago
Copy link