django-snowflake
Read-only Snowflake database backend for django
Usage
Add an entry to your DATABASES setting that uses django_snowflake as engine:
DATABASES = {
'snowflake_analytics': {
'ENGINE': 'django_snowflake',
'USER': 'my_db_user',
'PASSWORD': 'my_password',
'ACCOUNT': 'my_snowflake_Acc.eu-west1',
'DATABASE': 'SNOWFLAKE_SAMPLE_DATA',
'WAREHOUSE': 'WAREHOUSE_BACKEND',
}
}Modify wanted models Meta class with:
class Customer(models.Model):
C_CUSTKEY = models.IntegerField(primary_key=True)
C_NAME = models.CharField(max_length=25)
class Meta:
managed = False
db_table = 'SNOWFLAKE_SAMPLE_DATA.SCHEMA_1.CUSTOMER_TABLE'Working operations:
Customer.objects.all()
Customer.objects.all()[:100]
Customer.objects.all().count()
Customer.objects.get(C_CUSTKEY=1)
Customer.objects.filter(C_CUSTKEY__lte=10)
Customer.objects.filter(C_NAME__startwith='Custo')
Customer.objects.all().aggregate(Avg('C_CUSTKEY'))
#TODO Need more testingNext steps
Implements missing operations in operations.py using other SQL dialect as a base. [Postgres operations can be found here] (https://github.com/django/django/blob/ca9872905559026af82000e46cde6f7dedc897b6/django/db/backends/postgresql/operations.py)
React
Typescript
Django
Laravel
Facebook
Microsoft
Google
Alibaba
D3
Tencent