Note: Execute all these SQL commands in your Supabase SQL editor and ensure that they are executed sequentially in the order mentioned below.
- One Time Setup
Enable following extensions in your supabase project instance (Go to Database -> Extensions -> Search for the extension and click on the extension name to enable it):
pg_cronpg_netfuzzystrmatchwrappershttp
Execute all the queries sequentially in 01-one-time-setup folder in your SQL editor.
- Create base tables
- Execute all the queries sequentially in 02-base-table-creation folder in your SQL editor.
- Insert data into base tables
- Upload the csv file in 03-base-table-data-insertion folder to your created
chainstable.
- Materialized Views
- Execute all the sql files sequentially in the 04-materialized-views folder in your SQL editor.
- Function Setup
- Execute all the sql files sequentially in the 05-functions folder in your SQL editor.
- Go to Settings -> Database (Under Configuration) -> Coonection pooling configuration -> Change Pool Size to "45" from "15" (default)
- The secret key called "SUPABASE_ROYCO_FRONTEND" that you use in Goldksy -- change it to mode "Session" instead of "Transaction" (default) by getting the session based key from Supabase dashboard -- then, delete the exisiting pipeline from Goldsky dashboard and run "./deploy-new-pipelines.sh" to deploy the new pipelines, so that the change is triggered.
