8000 Add Oracle Data Connector recipe by sgrebnov · Pull Request #203 · spiceai/cookbook · GitHub
[go: up one dir, main page]
More Web Proxy on the site http://driver.im/
Skip to content

Add Oracle Data Connector recipe #203

New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

Sign up for GitHub

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Merged
merged 3 commits into from
Jul 8, 2025
Merged

Add Oracle Data Connector recipe #203

Show file tree
Hide file tree
Changes from all commits
Commits
Show all changes
3 commits
Select commit Hold shift + click to select a range
7dcc184
Add Oracle Data Connector recipe
sgrebnov Jul 7, 2025
85ec547
Add missing compose.yaml
sgrebnov Jul 8, 2025
0ff11c6
Improve
sgrebnov Jul 8, 2025
File filter

Filter by extension

Filter by extension
Conversations
Failed to load comments.
Loading
Jump to
Jump to file
Failed to load files.
Loading
Diff view
Diff view
1 change: 1 addition & 0 deletions README.md
View file
Open in desktop
Original file line number Diff line number Diff line change
Expand Up @@ -72,6 +72,7 @@ The Spice.ai OSS Cookbook is a collection of recipes for building and deploying
- [GraphQL Data Connector](./graphql/README.md)
- [MSSQL (Microsoft SQL Server) Data Connector](./mssql/README.md)
- [ODBC Data Connector](./odbc/README.md)
- [Oracle Data Connector](./oracle/README.md)
- [S3 Data Connector](./s3/README.md)
- [SharePoint/OneDrive for Business Data Connector](./sharepoint/README.md)
- [Snowflake Data Connector](./snowflake/README.md)
Expand Down
16 changes: 16 additions & 0 deletions oracle/Makefile
View file
Open in desktop
Original file line number Diff line number Diff line change
@@ -0,0 +1,16 @@
.PHONY: all
all: start

.PHONY: start
start:
@echo "Starting Oracle database container..."
@docker compose up --wait --detach oracle
@echo "Oracle database is running at localhost:15211"
@echo "Database: FREEPDB1"
@echo "Username: scott"
@echo "Password: tiger"

.PHONY: clean
clean:
@docker compose down --volumes --rmi local
@echo "Cleaned up project containers, volumes, and locally built images"
170 changes: 170 additions & 0 deletions oracle/README.md
View file
Open in desktop
Original file line number Diff line number Diff line change
@@ -0,0 +1,170 @@
# Oracle Data Connector

This cookbook demonstrates how to use Spice.ai to connect to and accelerate data from an Oracle database.

The demo includes an Oracle Free database container with sample TPCH data: `lineitem`, `orders`, and `customer`.

## Prerequisites

This recipe requires:

- [Oracle ODPI-C library](https://oracle.github.io/odpi/)
- [Docker](https://www.docker.com/) and [Docker Compose](https://docs.docker.com/compose/)
- [Spice CLI](https://docs.spice.ai/getting-started/install-spice) installed locally

## Step 1. Clone the repository and navigate to the Oracle cookbook

```bash
git clone https://github.com/spiceai/cookbook.git
cd cookbook/oracle
```

## Step 2. Create Oracle test database

Start the Oracle database container and populate it with sample TPC-H tables:

```bash
make
```

Output:

```bash
Starting Oracle database container...
[+] Running 2/2
✔ Network oracle_default Created 0.0s
✔ Container oracle-oracle-1 Healthy 10.7s
Oracle database is running at localhost:15211
Database: FREEPDB1
Username: scott
Password: tiger
```

## Step 3. Start Spice

```bash
make spice
```

This will start the Spice runtime, which will connect to Oracle and load the TPC-H tables:

```bash
2025/07/07 13:41:42 INFO Spice.ai runtime starting...
2025-07-07T20:41:42.882796Z INFO spiced: Starting runtime v1.5.0-unstable-build.2187f22e7+models
2025-07-07T20:41:42.884157Z INFO runtime::init::caching: Initialized results cache; max size: 128.00 MiB, item ttl: 1s
2025-07-07T20:41:42.884197Z INFO runtime::init::caching: Initialized search results cache;
2025-07-07T20:41:43.431896Z INFO runtime::flight: Spice Runtime Flight listening on 127.0.0.1:50051
2025-07-07T20:41:43.431929Z INFO runtime::opentelemetry: Spice Runtime OpenTelemetry listening on 127.0.0.1:50052
2025-07-07T20:41:43.432215Z INFO runtime::init::dataset: Initializing dataset lineitem
2025-07-07T20:41:43.432253Z INFO runtime::init::dataset: Initializing dataset orders
2025-07-07T20:41:43.432218Z INFO runtime::init::dataset: Initializing dataset customer
2025-07-07T20:41:43.432399Z INFO runtime::http: Spice Runtime HTTP listening on 127.0.0.1:8090
2025-07-07T20:41:43.915273Z INFO runtime::init::dataset: Dataset lineitem registered (oracle:"LINEITEM"), acceleration (arrow), results cache enabled.
2025-07-07T20:41:43.916361Z INFO runtime::init::dataset: Dataset orders registered (oracle:"ORDERS"), acceleration (arrow), results cache enabled.
2025-07-07T20:41:43.916382Z INFO runtime::accelerated_table::refresh_task: Loading data for dataset lineitem
2025-07-07T20:41:43.917524Z INFO runtime::accelerated_table::refresh_task: Loading data for dataset orders
2025-07-07T20:41:43.935174Z INFO runtime::init::dataset: Dataset customer registered (oracle:"CUSTOMER"), acceleration (arrow), results cache enabled.
2025-07-07T20:41:43.936280Z INFO runtime::accelerated_table::refresh_task: Loading data for dataset customer
2025-07-07T20:41:43.949015Z INFO runtime::accelerated_table::refresh_task: Loaded 7 rows (5.56 kiB) for dataset orders in 31ms.
2025-07-07T20:41:43.949027Z INFO runtime::accelerated_table::refresh_task: Loaded 27 rows (10.37 kiB) for dataset lineitem in 32ms.
2025-07-07T20:41:43.950450Z INFO runtime::accelerated_table::refresh_task: Loaded 7 rows (6.43 kiB) for dataset customer in 14ms.
2025-07-07T20:41:44.036153Z INFO runtime: All components are loaded. Spice runtime is ready!
```

## Step 4. Run queries against the dataset using the Spice SQL REPL

_In a new terminal_, start the Spice SQL REPL:

```bash
spice sql
```

List available tables:

```sql
show tables;
```

```bash
+---------------+--------------+--------------+------------+
| table_catalog | table_schema | table_name | table_type |
+---------------+--------------+--------------+------------+
| spice | runtime | task_history | BASE TABLE |
| spice | public | orders | BASE TABLE |
| spice | public | customer | BASE TABLE |
| spice | public | lineitem | BASE TABLE |
+---------------+--------------+--------------+------------+

Time: 0.018918625 seconds. 4 rows.
```

Query schema of the `lineitem` table:

```sql
describe lineitem;
```

```bash
+-----------------+-------------------+-------------+
| column_name | data_type | is_nullable |
+-----------------+-------------------+-------------+
| L_ORDERKEY | Int64 | YES |
| L_PARTKEY | Int64 | YES |
| L_SUPPKEY | Int64 | YES |
| L_LINENUMBER | Int64 | YES |
| L_QUANTITY | Decimal128(15, 2) | YES |
| L_EXTENDEDPRICE | Decimal128(15, 2) | YES |
| L_DISCOUNT | Decimal128(15, 2) | YES |
| L_TAX | Decimal128(15, 2) | YES |
| L_RETURNFLAG | Utf8 | YES |
| L_LINESTATUS | Utf8 | YES |
| L_SHIPDATE | Date32 | YES |
| L_COMMITDATE | Date32 | YES |
| L_RECEIPTDATE | Date32 | YES |
| L_SHIPINSTRUCT | Utf8 | YES |
| L_SHIPMODE | Utf8 | YES |
| L_COMMENT | Utf8 | YES |
+-----------------+-------------------+-------------+

Time: 0.005356291 seconds. 16 rows.
```

Calculate total sales by customer:

```sql
SELECT c.C_NAME, SUM(l.L_EXTENDEDPRICE) as total_sales
FROM customer c
JOIN orders o ON c.C_CUSTKEY = o.O_CUSTKEY
JOIN lineitem l ON o.O_ORDERKEY = l.L_ORDERKEY
GROUP BY c.C_NAME
ORDER BY total_sales DESC;
```

```bash
+--------------------+-------------+
| C_NAME | total_sales |
+--------------------+-------------+
| Customer#000001234 | 205084.32 |
| Customer#000000392 | 194779.11 |
| Customer#000000370 | 181861.27 |
| Customer#000000445 | 129137.97 |
| Customer#000001369 | 49432.60 |
| Customer#000000781 | 44694.46 |
| Customer#000000557 | 42560.31 |
+--------------------+-------------+

Time: 0.011594542 seconds. 7 rows.
```

## Clean Up

To stop and remove the Docker container:

```bash
make clean
```

## Learn more

[Oracle Data Connector Documentation](https://spiceai.org/docs/components/data-connectors/oracle)
[Data Acceleration](https://spiceai.org/docs/features/data-acceleration)
14 changes: 14 additions & 0 deletions oracle/compose.yaml
View file
Open in desktop
Original file line number Diff line number Diff line change
@@ -0,0 +1,14 @@
services:
oracle:
image: gvenzl/oracle-free:latest
environment:
ORACLE_PASSWORD: sys_Password1
ports:
- 15211:1521
volumes:
- ./data:/docker-entrypoint-initdb.d
healthcheck:
test: ["CMD-SHELL", "echo 'SELECT 1 FROM DUAL;' | sqlplus -S system/sys_Password1@localhost:1521/FREEPDB1 || exit 1"]
interval: 10s
timeout: 5s
retries: 10
129 changes: 129 additions & 0 deletions oracle/data/init.sql
View file
Open in desktop
Original file line number Diff line number Diff line change
@@ -0,0 +1,129 @@
-- TPCH Sample Data for Oracle Demo
-- This script runs as SYSTEM user and creates tables in the SCOTT schema

-- Connect to the pluggable database
ALTER SESSION SET CONTAINER = FREEPDB1;

-- Create the SCOTT user if it doesn't exist (fallback, should be created by container)
-- Using IDENTIFIED BY to ensure the user exists with the correct password
BEGIN
EXECUTE IMMEDIATE 'CREATE USER scott IDENTIFIED BY tiger';
EXCEPTION
WHEN OTHERS THEN
IF SQLCODE != -1920 THEN -- -1920 = user already exists
6DB6 RAISE;
END IF;
END;
/

-- Grant necessary privileges to SCOTT
GRANT CONNECT, RESOURCE TO scott;
GRANT CREATE SESSION TO scott;
GRANT CREATE TABLE TO scott;
GRANT CREATE VIEW TO scott;
GRANT CREATE SEQUENCE TO scott;
GRANT CREATE PROCEDURE TO scott;
GRANT UNLIMITED TABLESPACE TO scott;

-- Now connect as SCOTT user to create tables in SCOTT schema
CONNECT scott/tiger@localhost:1521/FREEPDB1;

-- Create TPCH lineitem table
CREATE TABLE lineitem (
L_ORDERKEY NUMBER(10,0) NOT NULL,
L_PARTKEY NUMBER(10,0) NOT NULL,
L_SUPPKEY NUMBER(10,0) NOT NULL,
L_LINENUMBER NUMBER(10,0) NOT NULL,
L_QUANTITY NUMBER(15,2) NOT NULL,
L_EXTENDEDPRICE NUMBER(15,2) NOT NULL,
L_DISCOUNT NUMBER(15,2) NOT NULL,
L_TAX NUMBER(15,2) NOT NULL,
L_RETURNFLAG CHAR(1) NOT NULL,
L_LINESTATUS CHAR(1) NOT NULL,
L_SHIPDATE DATE NOT NULL,
L_COMMITDATE DATE NOT NULL,
L_RECEIPTDATE DATE NOT NULL,
L_SHIPINSTRUCT CHAR(25) NOT NULL,
L_SHIPMODE CHAR(10) NOT NULL,
L_COMMENT VARCHAR2(44) NOT NULL
);

-- Insert sample TPCH lineitem data
INSERT INTO lineitem VALUES (1, 15519, 785, 1, 17.00, 21168.23, 0.04, 0.02, 'N', 'O', DATE '1996-03-13', DATE '1996-02-12', DATE '1996-03-22', 'DELIVER IN PERSON', 'TRUCK', 'egular courts above the');
INSERT INTO lineitem VALUES (1, 67310, 7311, 2, 36.00, 45983.16, 0.09, 0.06, 'N', 'O', DATE '1996-04-12', DATE '1996-02-28', DATE '1996-04-20', 'TAKE BACK RETURN', 'MAIL', 'ly final dependencies: slyly bold');
INSERT INTO lineitem VALUES (1, 63700, 3701, 3, 8.00, 13309.60, 0.10, 0.02, 'N', 'O', DATE '1996-01-29', DATE '1996-12-31', DATE '1996-01-31', 'TAKE BACK RETURN', 'REG AIR', 'riously. regular, express dep');
INSERT INTO lineitem VALUES (1, 2132, 4633, 4, 28.00, 28955.64, 0.09, 0.06, 'N', 'O', DATE '1996-04-21', DATE '1996-03-30', DATE '1996-05-16', 'NONE', 'AIR', 'lites. fluffily even de');
INSERT INTO lineitem VALUES (1, 24027, 1534, 5, 24.00, 22824.48, 0.10, 0.04, 'N', 'O', DATE '1996-03-30', DATE '1996-03-14', DATE '1996-04-01', 'NONE', 'FOB', ' pending foxes. slyly re');
INSERT INTO lineitem VALUES (1, 15635, 638, 6, 32.00, 49620.16, 0.07, 0.02, 'N', 'O', DATE '1996-01-30', DATE '1996-02-07', DATE '1996-02-03', 'DELIVER IN PERSON', 'MAIL', 'arefully slyly ex');
INSERT INTO lineitem VALUES (2, 106170, 1191, 1, 38.00, 44694.46, 0.00, 0.05, 'N', 'O', DATE '1997-01-28', DATE '1997-01-14', DATE '1997-02-02', 'TAKE BACK RETURN', 'RAIL', 'ven requests. deposits breach a');
INSERT INTO lineitem VALUES (3, 4297, 1798, 1, 45.00, 54058.05, 0.06, 0.00, 'R', 'F', DATE '1994-02-02', DATE '1994-01-04', DATE '1994-02-23', 'NONE', 'AIR', 'ongside of the furiously express');
INSERT INTO lineitem VALUES (3, 19036, 6540, 2, 49.00, 46796.47, 0.10, 0.00, 'R', 'F', DATE '1993-11-09', DATE '1993-12-20', DATE '1993-11-20', 'TAKE BACK RETURN', 'RAIL', ' unusual accounts. eve');
INSERT INTO lineite 9E12 m VALUES (3, 128449, 3474, 3, 27.00, 39890.88, 0.06, 0.07, 'A', 'F', DATE '1994-01-16', DATE '1993-11-22', DATE '1994-01-23', 'DELIVER IN PERSON', 'SHIP', 'nal foxes wake quickly');
INSERT INTO lineitem VALUES (3, 29380, 1883, 4, 2.00, 2618.76, 0.01, 0.06, 'A', 'F', DATE '1993-12-04', DATE '1994-01-07', DATE '1994-01-01', 'NONE', 'TRUCK', 'y. fluffily pending d');
INSERT INTO lineitem VALUES (3, 183095, 650, 5, 28.00, 32986.52, 0.04, 0.00, 'R', 'F', DATE '1993-12-14', DATE '1994-01-10', DATE '1994-01-01', 'NONE', 'FOB', 'ar deposits. blithely final');
INSERT INTO lineitem VALUES (3, 62143, 9158, 6, 26.00, 28733.64, 0.10, 0.02, 'A', 'F', DATE '1993-10-29', DATE '1993-12-18', DATE '1993-11-04', 'TAKE BACK RETURN', 'RAIL', 'sleep quickly. req');
INSERT INTO lineitem VALUES (4, 88035, 5560, 1, 30.00, 28681.50, 0.03, 0.08, 'N', 'O', DATE '1996-01-10', DATE '1995-12-14', DATE '1996-01-18', 'DELIVER IN PERSON', 'REG AIR', '- quickly regular packages sleep');
INSERT INTO lineitem VALUES (4, 5794, 8295, 2, 4.00, 4846.16, 0.09, 0.08, 'N', 'O', DATE '1996-12-28', DATE '1996-12-09', DATE '1997-01-14', 'TAKE BACK RETURN', 'AIR', 'eep blithely bold accou');
INSERT INTO lineitem VALUES (4, 169544, 4556, 3, 11.00, 15904.94, 0.10, 0.03, 'N', 'O', DATE '1996-10-21', DATE '1996-11-17', DATE '1996-10-30', 'NONE', 'REG AIR', 'ar accounts detect slyly');
INSERT INTO lineitem VALUES (5, 108570, 8571, 1, 15.00, 19754.55, 0.02, 0.04, 'R', 'F', DATE '1994-08-08', DATE '1994-10-13', DATE '1994-08-25', 'DELIVER IN PERSON', 'AIR', 'eep blithely bold accou');
INSERT INTO lineitem VALUES (5, 123927, 3928, 2, 26.00, 32281.92, 0.07, 0.08, 'R', 'F', DATE '1994-10-16', DATE '1994-09-25', DATE '1994-10-19', 'NONE', 'FOB', 'ests wake carefully ca');
INSERT INTO lineitem VALUES (5, 37531, 7532, 3, 50.00, 77101.50, 0.08, 0.03, 'A', 'F', DATE '1994-08-13', DATE '1994-10-30', DATE '1994-08-25', 'DELIVER IN PERSON', 'SHIP', 'y pending requests integrate');
INSERT INTO lineitem VALUES (6, 139636, 2150, 1, 37.00, 42560.31, 0.08, 0.03, 'A', 'F', DATE '1992-04-27', DATE '1992-05-15', DATE '1992-05-02', 'TAKE BACK RETURN', 'TRUCK', 'p furiously special foxes');
INSERT INTO lineitem VALUES (7, 182052, 9607, 1, 12.00, 14202.60, 0.07, 0.03, 'N', 'O', DATE '1996-05-07', DATE '1996-03-13', DATE '1996-06-03', 'NONE', 'FOB', ' haggle. carefully express');
INSERT INTO lineitem VALUES (7, 145243, 7750, 2, 9.00, 11804.16, 0.08, 0.08, 'N', 'O', DATE '1996-02-01', DATE '1996-03-02', DATE '1996-02-19', 'TAKE BACK RETURN', 'SHIP', 'y agreements. slyly bold');
INSERT INTO lineitem VALUES (7, 94780, 2290, 3, 46.00, 43645.88, 0.10, 0.07, 'N', 'O', DATE '1996-01-15', DATE '1996-03-27', DATE '1996-02-03', 'COLLECT COD', 'MAIL', ' unusual, regular acco');
INSERT INTO lineitem VALUES (7, 163073, 3074, 4, 28.00, 32293.96, 0.03, 0.04, 'N', 'O', DATE '1996-03-21', DATE '1996-04-08', DATE '1996-04-16', 'NONE', 'FOB', 'ly special requests ');
INSERT INTO lineitem VALUES (7, 156323, 8838, 5, 38.00, 54700.16, 0.05, 0.08, 'N', 'O', DATE '1996-02-11', DATE '1996-02-24', DATE '1996-02-26', 'DELIVER IN PERSON', 'TRUCK', 'ns haggle carefully ironic deposits');
INSERT INTO lineitem VALUES (7, 40921, 922, 6, 35.00, 33482.20, 0.06, 0.03, 'N', 'O', DATE '1996-01-16', DATE '1996-02-23', DATE '1996-01-22', 'TAKE BACK RETURN', 'FOB', 'jole. excuses wake carefully');
INSERT INTO lineitem VALUES (7, 21636, 1637, 7, 5.00, 4650.15, 0.04, 0.02, 'N', 'O', DATE '1996-02-10', DATE '1996-03-26', DATE '1996-02-11', 'NONE', 'MAIL', 'ithely regula');

-- Create additional sample tables for a more complete demonstration
CREATE TABLE orders (
O_ORDERKEY NUMBER(10,0) NOT NULL,
O_CUSTKEY NUMBER(10,0) NOT NULL,
O_ORDERSTATUS CHAR(1) NOT NULL,
O_TOTALPRICE NUMBER(15,2) NOT NULL,
O_ORDERDATE DATE NOT NULL,
O_ORDERPRIORITY CHAR(15) NOT NULL,
O_CLERK CHAR(15) NOT NULL,
O_SHIPPRIORITY NUMBER(10,0) NOT NULL,
O_COMMENT VARCHAR2(79) NOT NULL
);

INSERT INTO orders VALUES (1, 370, 'O', 172799.49, DATE '1996-01-02', '5-LOW', 'Clerk#000000951', 0, 'nstructions sleep furiously among');
INSERT INTO orders VALUES (2, 781, 'O', 38426.09, DATE '1996-12-01', '1-URGENT', 'Clerk#000000880', 0, ' foxes. pending, express requests');
INSERT INTO orders VALUES (3, 1234, 'F', 205654.30, DATE '1993-10-14', '5-LOW', 'Clerk#000000955', 0, 'sly final accounts boost. careful');
INSERT INTO orders VALUES (4, 1369, 'O', 56000.91, DATE '1995-10-11', '5-LOW', 'Clerk#000000124', 0, 'sits. slyly regular packages');
INSERT INTO orders VALUES (5, 445, 'F', 144659.20, DATE '1994-07-30', '5-LOW', 'Clerk#000000925', 0, 'quickly. bold deposits sleep slyly');
INSERT INTO orders VALUES (6, 557, 'F', 58749.59, DATE '1992-02-21', '4-NOT SPECIFIED', 'Clerk#000000058', 0, 'ggle. special, final requests');
INSERT INTO orders VALUES (7, 392, 'O', 252004.18, DATE '1996-01-10', '2-HIGH', 'Clerk#000000470', 0, 'ly special requests');

CREATE TABLE customer (
C_CUSTKEY NUMBER(10,0) NOT NULL,
C_NAME VARCHAR2(25) NOT NULL,
C_ADDRESS VARCHAR2(40) NOT NULL,
C_NATIONKEY NUMBER(10,0) NOT NULL,
C_PHONE CHAR(15) NOT NULL,
C_ACCTBAL NUMBER(15,2) NOT NULL,
C_MKTSEGMENT CHAR(10) NOT NULL,
C_COMMENT VARCHAR2(117) NOT NULL
);

INSERT INTO customer VALUES (370, 'Customer#000000370', 'ynhwmJwzBsL9LWLm', 12, '22-895-641-3466', 1414.29, 'BUILDING', 'ully regular requests. final, regular');
INSERT INTO customer VALUES (781, 'Customer#000000781', 'mZzPbk9A6hXhxXq', 17, '27-329-829-2043', 9506.60, 'AUTOMOBILE', 'ular excuses wake slyly');
INSERT INTO customer VALUES (1234, 'Customer#000001234', 'QxCzH8wuenFOaTC', 8, '18-999-999-9999', 7895.12, 'HOUSEHOLD', 'accounts sleep furiously');
INSERT INTO customer VALUES (1369, 'Customer#000001369', 'TyaxLMoKjibF40h', 18, '28-555-555-5555', 4536.89, 'MACHINERY', 'blithely pending packages');
INSERT INTO customer VALUES (445, 'Customer#000000445', 'GzEzNm4UjFv6BXl', 7, '17-777-777-7777', 2345.67, 'FURNITURE', 'special packages wake');
INSERT INTO customer VALUES (557, 'Customer#000000557', 'OzMwqcDnH4BxSJe', 23, '33-333-333-3333', 6789.01, 'BUILDING', 'carefully final requests');
INSERT INTO customer VALUES (392, 'Customer#000000392', 'GhJyNmJdYs2xHVe', 2, '12-222-222-2222', 8901.23, 'AUTOMOBILE', 'special, express packages');

-- Create primary keys for better performance
ALTER TABLE lineitem ADD CONSTRAINT pk_lineitem PRIMARY KEY (L_ORDERKEY, L_LINENUMBER);
ALTER TABLE orders ADD CONSTRAINT pk_orders PRIMARY KEY (O_ORDERKEY);
ALTER TABLE customer ADD CONSTRAINT pk_customer PRIMARY KEY (C_CUSTKEY);

-- Create foreign keys for referential integrity
ALTER TABLE lineitem ADD CONSTRAINT fk_lineitem_order FOREIGN KEY (L_ORDERKEY) REFERENCES orders(O_ORDERKEY);
ALTER TABLE orders ADD CONSTRAINT fk_orders_customer FOREIGN KEY (O_CUSTKEY) REFERENCES customer(C_CUSTKEY);

COMMIT;
29 changes: 29 additions & 0 deletions oracle/spicepod.yaml
View file
Open in desktop
Original file line number Diff line number Diff line change
@@ -0,0 +1,29 @@
version: v1
kind: Spicepod
name: oracle-tpch

connection: &params
oracle_host: localhost
oracle_port: 15211
oracle_username: scott
oracle_password: tiger
oracle_service_name: FREEPDB1

datasets:
- from: oracle:"LINEITEM"
name: lineitem
params: *params
acceleration:
enabled: true

- from: oracle:"ORDERS"
name: orders
params: *params
acceleration:
enabled: true

- from: oracle:"CUSTOMER"
name: customer
params: *params
acceleration:
enabled: true
0