{ "cells": [ { "cell_type": "code", "execution_count": 6, "id": "e7755adc", "metadata": {}, "outputs": [ { "data": { "text/html": [ "
\n", "\n", "\n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", "
name
0card_dataset_dashboard_mapping
1card_filter_info
2card_info
3dashboard_info
4dataset_ddl
\n", "
" ], "text/plain": [ " name\n", "0 card_dataset_dashboard_mapping\n", "1 card_filter_info\n", "2 card_info\n", "3 dashboard_info\n", "4 dataset_ddl" ] }, "execution_count": 6, "metadata": {}, "output_type": "execute_result" } ], "source": [ "import pandas as pd\n", "import duckdb\n", "\n", "conn = duckdb.connect(database = \"./duckdb/bi_metadata.duckdb\")\n", "conn.sql(\"show tables\").df()\n" ] }, { "cell_type": "code", "execution_count": 12, "id": "c8f35aba", "metadata": {}, "outputs": [ { "data": { "text/plain": [ "┌────────────┬──────────────────────────────────────────────────────────────────────────────────────────────────────────────────────┐\n", "│ dataset_id │ dataset_ddl │\n", "│ varchar │ varchar │\n", "├────────────┼──────────────────────────────────────────────────────────────────────────────────────────────────────────────────────┤\n", "│ DS0001 │ CREATE TABLE ds0001 (\\n bbk_id VARCHAR,\\n stat_date DATE,\\n metric_value DOUBLE,\\n dimension VARCHAR\\n); │\n", "│ DS0002 │ CREATE TABLE ds0002 (\\n bbk_id VARCHAR,\\n stat_date DATE,\\n metric_value DOUBLE,\\n dimension VARCHAR\\n); │\n", "│ DS0003 │ CREATE TABLE ds0003 (\\n bbk_id VARCHAR,\\n stat_date DATE,\\n metric_value DOUBLE,\\n dimension VARCHAR\\n); │\n", "│ DS0004 │ CREATE TABLE ds0004 (\\n bbk_id VARCHAR,\\n stat_date DATE,\\n metric_value DOUBLE,\\n dimension VARCHAR\\n); │\n", "│ DS0005 │ CREATE TABLE ds0005 (\\n bbk_id VARCHAR,\\n stat_date DATE,\\n metric_value DOUBLE,\\n dimension VARCHAR\\n); │\n", "│ DS0006 │ CREATE TABLE ds0006 (\\n bbk_id VARCHAR,\\n stat_date DATE,\\n metric_value DOUBLE,\\n dimension VARCHAR\\n); │\n", "│ DS0007 │ CREATE TABLE ds0007 (\\n bbk_id VARCHAR,\\n stat_date DATE,\\n metric_value DOUBLE,\\n dimension VARCHAR\\n); │\n", "│ DS0008 │ CREATE TABLE ds0008 (\\n bbk_id VARCHAR,\\n stat_date DATE,\\n metric_value DOUBLE,\\n dimension VARCHAR\\n); │\n", "│ DS0009 │ CREATE TABLE ds0009 (\\n bbk_id VARCHAR,\\n stat_date DATE,\\n metric_value DOUBLE,\\n dimension VARCHAR\\n); │\n", "│ DS0010 │ CREATE TABLE ds0010 (\\n bbk_id VARCHAR,\\n stat_date DATE,\\n metric_value DOUBLE,\\n dimension VARCHAR\\n); │\n", "│ · │ · │\n", "│ · │ · │\n", "│ · │ · │\n", "│ DS0016 │ CREATE TABLE ds0016 (\\n bbk_id VARCHAR,\\n stat_date DATE,\\n metric_value DOUBLE,\\n dimension VARCHAR\\n); │\n", "│ DS0017 │ CREATE TABLE ds0017 (\\n bbk_id VARCHAR,\\n stat_date DATE,\\n metric_value DOUBLE,\\n dimension VARCHAR\\n); │\n", "│ DS0018 │ CREATE TABLE ds0018 (\\n bbk_id VARCHAR,\\n stat_date DATE,\\n metric_value DOUBLE,\\n dimension VARCHAR\\n); │\n", "│ DS0019 │ CREATE TABLE ds0019 (\\n bbk_id VARCHAR,\\n stat_date DATE,\\n metric_value DOUBLE,\\n dimension VARCHAR\\n); │\n", "│ DS0020 │ CREATE TABLE ds0020 (\\n bbk_id VARCHAR,\\n stat_date DATE,\\n metric_value DOUBLE,\\n dimension VARCHAR\\n); │\n", "│ DS0021 │ CREATE TABLE ds0021 (\\n bbk_id VARCHAR,\\n stat_date DATE,\\n metric_value DOUBLE,\\n dimension VARCHAR\\n); │\n", "│ DS0022 │ CREATE TABLE ds0022 (\\n bbk_id VARCHAR,\\n stat_date DATE,\\n metric_value DOUBLE,\\n dimension VARCHAR\\n); │\n", "│ DS0023 │ CREATE TABLE ds0023 (\\n bbk_id VARCHAR,\\n stat_date DATE,\\n metric_value DOUBLE,\\n dimension VARCHAR\\n); │\n", "│ DS0024 │ CREATE TABLE ds0024 (\\n bbk_id VARCHAR,\\n stat_date DATE,\\n metric_value DOUBLE,\\n dimension VARCHAR\\n); │\n", "│ DS0025 │ CREATE TABLE ds0025 (\\n bbk_id VARCHAR,\\n stat_date DATE,\\n metric_value DOUBLE,\\n dimension VARCHAR\\n); │\n", "├────────────┴──────────────────────────────────────────────────────────────────────────────────────────────────────────────────────┤\n", "│ 25 rows (20 shown) 2 columns │\n", "└───────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────┘" ] }, "execution_count": 12, "metadata": {}, "output_type": "execute_result" } ], "source": [ "conn.sql(\"select * from dataset_ddl\")\n" ] } ], "metadata": { "kernelspec": { "display_name": ".venv (3.13.3)", "language": "python", "name": "python3" }, "language_info": { "codemirror_mode": { "name": "ipython", "version": 3 }, "file_extension": ".py", "mimetype": "text/x-python", "name": "python", "nbconvert_exporter": "python", "pygments_lexer": "ipython3", "version": "3.13.3" } }, "nbformat": 4, "nbformat_minor": 5 }