All Products
Document Center

Create a table

Last Updated: May 27, 2020

Unlike creating MySQL tables, to create tables of an SQLServer, PostgreSQL, or Oracle database, you need to specify the schema name and table name in table_mapping.

  1. create external table person (
  2. id int,
  3. name varchar(1023),
  4. age int
  5. ) tblproperties(
  6. table_mapping = 'test_oracle.person'
  7. );

Then, you can connect the Oracle client to Data Lake Analytics (DLA) to read data from the Oracle database.