1. Connecting
    1. CLI
    2. Python API
  2. URLs
  3. Type Conversion
  4. Limitations and Constraints



recap ls snowflake://user:pass@my-account/testdb?warehouse=some_dwh&role=some_role
recap schema snowflake://user:pass@my-account/testdb/public/testtable?warehouse=some_dwh&role=some_role

Python API

from recap.clients import create_client

with create_client("snowflake://user:pass@my-account") as client:"testdb")
    client.schema("testdb", "public", "testtable")


Recap’s Snowflake client uses Snowflake’s SQLAlchemy URL format:


The schema component is not a data model schema. It’s Snowflake’s schema, which is similar to a namespace. schema is usually public.

Type Conversion

Snowflake Type Recap Type
float, float4, float8, double, double precision, real FloatType (bits=64)
boolean BoolType
number, decimal, numeric, int, integer, bigint, smallint, tinyint, byteint BytesType (logical=”build.recap.Decimal”, bytes_=16, variable=False, precision=NUMERIC_PRECISION, scale=NUMERIC_SCALE)
varchar, string, text, nvarchar, nvarchar2, char varying, nchar varying StringType (bytes_=OCTET_LENGTH, variable=True)
char, nchar, character StringType (bytes_=OCTET_LENGTH, variable=True)
binary, varbinary, blob BytesType (bytes_=OCTET_LENGTH)
date IntType(bits=32, logical=”build.recap.Date”, unit=”day”)
timestamp, datetime IntType(bits=64, logical=”build.recap.Timestamp”, unit=unit)
time IntType(bits=32, logical=”build.recap.Time”, unit=unit)

Limitations and Constraints

The conversion functions raise a ValueError exception if the conversion is not possible.