DDL parase and Convert to BigQuery JSON schema and DDL statements
BSD-3-CLAUSE License
Bot releases are hidden (Show)
Published by shinichi-takii almost 4 years ago
STRING
BYTES
BINARY
VARBINARY
BYTEA
Published by shinichi-takii about 4 years ago
DdlParseColumn.character_set
property.Published by shinichi-takii about 4 years ago
DdlParseColumn.default
property.DdlParseColumn.auto_increment
property.DdlParseColumn.encode
property.DdlParseColumn.distkey
property.DdlParseColumn.sortkey
property.Published by shinichi-takii about 4 years ago
ENCODE
attribute.Published by shinichi-takii over 4 years ago
DdlParseColumn.is_unsigned
DdlParseColumn.is_zerofill
UNSIGNED
ZEROFILL
TINYINT
SMALLINT
MEDIUMINT
DEC
FIXED
Published by shinichi-takii over 4 years ago
Published by shinichi-takii almost 5 years ago
NUMERIC
data type.BigQuery Data Type | Source Data Type | Precision | Scale | Database | Exapmle Source Data Type |
---|---|---|---|---|---|
INT64 | (NUMERIC|NUMBER|DECIMAL) | < 19 | = 0 | - | NUMERIC(18) |
FLOAT64 | (NUMERIC|NUMBER|DECIMAL) | < 19 | > 0 | - | NUMERIC(18, 1) |
NUMERIC | (NUMERIC|NUMBER|DECIMAL) | >= 19 | - | - | NUMERIC(19) |
NUMERIC | (NUMERIC|NUMBER|DECIMAL) | * | - | - | NUMBER(*, 0) |
INT64 | (NUMERIC|NUMBER|DECIMAL) | None | - | default | DECIMAL |
NUMERIC | (NUMERIC|NUMBER|DECIMAL) | None | - |
DdlParse.DATABASE.oracle DdlParse.DATABASE.postgresql
|
NUMBERNUMERIC |
(*)
format of Oracle NUMBER
data type.Published by shinichi-takii almost 5 years ago
Published by shinichi-takii over 5 years ago
COMMENT
statements.DdlParseColumn.comment
property.DdlParseColumn.description
property for the DdlParseColumn.comment
property alias.Published by shinichi-takii over 5 years ago
FOREIGN KEY
.Published by shinichi-takii over 5 years ago
UUID
DEFAULT
value.
DEFAULT
value.Published by shinichi-takii over 5 years ago
CHARACTER VARYING
JSON
DEFAULT
value.
DEFAULT
parse character.Published by shinichi-takii almost 6 years ago
DdlParseTable.to_bigquery_ddl
function. (#20)
DdlParseColumn.bigquery_legacy_data_type
property. (#21)
DdlParseColumn.bigquery_data_type
property.DdlParseColumn.bigquery_standard_data_type
property. (#22)
Published by shinichi-takii over 6 years ago
Published by shinichi-takii over 6 years ago
CLOB
, NCLOB
(#9)NUMBER
with no length & scale specification (#10)Published by shinichi-takii over 6 years ago
Published by shinichi-takii over 6 years ago
source_database
option. (#7)to_bigquery_fields
method to Columns dicttionary(DdlParseColumnDict
class). (#5)Published by shinichi-takii over 6 years ago
Published by shinichi-takii almost 7 years ago
ddlparse.py
: Exclude unused module.example.py
: Modified comment.README.md
: Miner fix.