{
 "cells": [
  {
   "cell_type": "code",
   "execution_count": 6,
   "id": "e7755adc",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>name</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>card_dataset_dashboard_mapping</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>card_filter_info</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>card_info</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>dashboard_info</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>dataset_ddl</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "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
}