| CREATE TABLE IF NOT EXISTS `YOUR_PROJECT_ID.YOUR_DATASET.tools` ( | |
| tool_id STRING NOT NULL, | |
| slug STRING NOT NULL, | |
| name STRING NOT NULL, | |
| summary STRING NOT NULL, | |
| category STRING NOT NULL, | |
| repo_url STRING NOT NULL, | |
| website_url STRING, | |
| submitted_by STRING NOT NULL, | |
| created_at TIMESTAMP NOT NULL | |
| ) | |
| PARTITION BY DATE(created_at) | |
| CLUSTER BY category, slug; | |
| CREATE TABLE IF NOT EXISTS `YOUR_PROJECT_ID.YOUR_DATASET.tool_ratings` ( | |
| tool_id STRING NOT NULL, | |
| voter_id STRING NOT NULL, | |
| rating INT64 NOT NULL, | |
| created_at TIMESTAMP NOT NULL, | |
| updated_at TIMESTAMP NOT NULL | |
| ) | |
| PARTITION BY DATE(created_at) | |
| CLUSTER BY tool_id, voter_id; | |