Iceberg and Delta Lake tables can be queried in a SQL statement like any other database table. They are referenced using a 3-level dot notation: <datalakeName>.<databaseName>.<tableName>.
Examples of Select Queries
/* Simple SELECT using 3-level dot notation for Iceberg table*/
SELECT COUNT(*) FROM datalake_deltalake_glue.db1.t1;
*** Query completed. One row found. One column returned.
*** Total elapsed time was 2 seconds.
Count(*)
-----------
6
/* Queries with projection lists & predicates */
SELECT c1,c2 FROM Iceberg1.db1.t1 where order_date > ‘10-21-2020’ and make = ‘Buick’;
/* Join BFS and OTF tables */
SELECT * FROM datalake_iceberg_glue.db1.t1 AS D WHERE loc_tbl.make = D.make;
/*Join two OTF derived tables from different data lakes */
WITH rtbl AS ( SELECT * FROM Iceberg_glue.db1.t1),
ltbl AS ( SELECT * FROM Iceberg_unity.db2.t2)
SELECT TOP 5 * FROM rtbl, ltbl;
/* Create Table as */
CREATE TABLE cdata_loc AS (SELECT * FROM iceberg_glue.d1.t1 as D) WITH DATA;