Upload Samples for the Semantic Model Extensions Use Cases

For learning purposes, use the samples mentioned in the use cases and perform the user extensions.

Prior to using the samples in the user extensions, you must ensure that the samples mentioned in the use cases are available in the applicable autonomous data warehouse.

1. Download these samples to your local machine.
2. Connect to the applicable autonomous data warehouse using SQL Developer Client and the OAX_USER credentials. See Connect Fusion Data Intelligence to an Autonomous Data Warehouse with SQL Developer Desktop Client.
3. Create the sample table in the autonomous data warehouse using either of the options:
   • In SQL Developer Client, import the applicable .xlsx file, based on the use case, from your local machine into the applicable autonomous data warehouse using these steps:
     1. Right click Tables and then click Import Data.
     2. In step 1 of the Data Import Wizard, select Local File in Source, click Browse for File, and select the applicable .xlsx file, based on the use case; for example, FDI_X_COUNTRY.xlsx, from your local machine, and then click Next.
     3. In step 2 of the Data Import Wizard, enter a name in Table Name, review the file contents in the File Contents section, and then click Next.
     4. In steps 3 and 4 of the Data Import Wizard, review and click Next.
     5. In step 5 of the Data Import Wizard, click Finish.
   • Based on the use case, if the sample table is a .sql file, execute the data definition language (DDL) .sql using these steps:
     1. Click File, click Open, and then select the applicable .sql file, based on the use case, that you saved on your local machine; for example, FDI_X_COUNTRY.sql.
     2. Under SQL Worksheet on the right pane, click the Run Script icon.
     3. View the script output in the Script output area.
4. Create an SQL view using these steps:
   1. Right click Views and click New View.
   2. In Create View, verify that you see the appropriate value in Schema, provide an applicable name for the view based on the use case in Name, under the SQL Query tab, in the SQL Query area, provide the SQL script mentioned in the applicable use case, and then click OK.
5. Grant semantic model access to the database object for the OAX$OAC schema using these steps:
   1. In Views, right click the applicable view, click Privileges, and then click Grant.
   2. In Perform Grant Action, click SQL tab, provide the SQL script mentioned in the applicable use case, and then click Apply.
6. Under SQL Worksheet on the right pane, provide the SQL script mentioned in the applicable use case, and then click the Run Statement icon to validate that the data is loading from the sample table as expected.