Closed bindipankhudi closed 3 days ago
The airbyte/types.py
file has been updated to enhance the to_sql_type
function. Specifically, a new condition has been added to return sqlalchemy.types.JSON()
when json_schema_type
is "dict." This change allows for better handling of dictionary types within JSON schemas, ensuring they are correctly mapped to the appropriate SQL type.
File | Change Summary |
---|---|
airbyte/types.py |
Added a condition to return sqlalchemy.types.JSON() when json_schema_type is "dict" in the to_sql_type function. |
sequenceDiagram
participant User
participant to_sql_type Function
participant SQLAlchemy JSON Type
User->>to_sql_type Function: Call with json_schema_type="dict"
to_sql_type Function-->>SQLAlchemy JSON Type: Return sqlalchemy.types.JSON()
SQLAlchemy JSON Type-->>User: Receive JSON type for "dict"
In the code, a change so neat,
For dictionaries, a special treat!
JSON types now fit just right,
Mapping schemas, day or night.
🐇✨ SQL's delight,
With every dict, the future's bright!
Thank you for using CodeRabbit. We offer it for free to the OSS community and would appreciate your support in helping us grow. If you find it useful, would you consider giving us a shout-out on your favorite social media?
Closing as stale; I think we need a bit more time here but as of now it is not a high priority. We may re-open/revise in future.
Related to https://github.com/airbytehq/PyAirbyte/issues/210
Summary by CodeRabbit
json_schema_type
is "dict."