refactor(snowflake): replace custom temp table ddl for memtables with… #12

	name: TPC-H

	on:
	push:
	paths-ignore:
	- "docs/**"
	- "mkdocs.yml"
	- "*/.md"
	branches:
	- master
	- "*.x.x"
	pull_request:
	paths-ignore:
	- "docs/**"
	- "mkdocs.yml"
	- "*/.md"
	branches:
	- master
	- "*.x.x"
	merge_group:

	concurrency:
	group: ${{ github.repository }}-${{ github.head_ref \|\| github.sha }}-${{ github.workflow }}
	cancel-in-progress: true

	jobs:
	tpch:
	runs-on: ubuntu-latest
	steps:
	- name: checkout
	uses: actions/checkout@v3

	- name: clone tpc-queries
	uses: actions/checkout@v3
	with:
	repository: ibis-project/tpc-queries
	path: ./tpc-queries
	ref: master

	- name: install python
	uses: actions/setup-python@v4
	id: install_python
	with:
	python-version: "3.11"

	- name: install tpc-queries dependencies
	working-directory: tpc-queries
	run: \|
	python -m pip install -r requirements.txt
	python -m pip install -U 'duckdb>=0.4' 'duckdb-engine>=0.6'

	- name: install ibis
	run: python -m pip install ".[sqlite,duckdb]"

	- name: generate tpc-h data
	working-directory: tpc-queries
	run: python -c "import duckdb; duckdb.connect('tpch.ddb').execute('CALL dbgen(sf=0.1)')"

	- name: run tpc-h queries
	working-directory: tpc-queries
	run: ./runtpc -i ibis -i duckdb -d 'tpch.ddb' -b 'duckdb'

Provide feedback