1CREATE NAMESPACE lightning.datasource.rdbms;
2CREATE NAMESPACE lightning.lakehouse
3
4REGISTER OR REPLACE JDBC DATASOURCE tpcds_postgres OPTIONS(
5 driver "org.postgresql.Driver",
6 url "jdbc:postgresql://example-postgres.database.azure.com:5432/sample_db",
7 user "demo_user",
8 password "********"
9) NAMESPACE lightning.datasource.rdbms
10
11REGISTER OR REPLACE JDBC DATASOURCE tpcds_postgres OPTIONS(
12 driver "org.postgresql.Driver",
13 url "jdbc:postgresql://example-db.region.rds.amazonaws.com:5432/tpcds_db",
14 user "demo_user",
15 password "********"
16) NAMESPACE lightning.datasource.rdbms
17
18SHOW ERD IN lightning.datasource.rdbms.tpcds_postgres.public
19SHOW ERD IN lightning.datasource.rdbms.tpcds_postgres
20
21LOAD USL tpcds NAMESPACE lightning.metastore.usldb
22
23LOAD USL my_usl NAMESPACE lightning.metastore.usldb
24
25DESC lightning.metastore.usldb.tpcds.customer
26
27SELECT distinct i_rec_start_date FROM lightning.datasource.iceberg.tpcbenchmark.tpcds.item TABLESAMPLE (100 PERCENT)
28
29RUN DQ cc_call_center_sk TABLE lightning.metastore.usldb.tpcds.call_center
30
31RUN DQ cc_closed_date_sk TABLE lightning.metastore.usldb.tpcds.call_center
32
33LOAD USL dp_uls_001 NAMESPACE lightning.metastore.usldb
34
35show namespaces or tables in lightning.datasource.iceberg.tpcbenchmark.tpcds
36
37show tables in lightning
38
39DESC lightning.metastore.usldb.tpcds.catalog_page
40
41show namespaces in lightning.lakehouse.iceberg