@kapa.ai is it ok to delete data from airbyte_ normalized tables ? for example for shopify I have

_airbyte_raw_products

and

_airbyte_raw_orders

table

The

_airbyte_raw_

tables are created by Airbyte during the data synchronization process. These tables contain raw data from your source, stored as JSON blobs. If you have Basic Normalization enabled, Airbyte uses this raw data to create a schema and tables with your data in mind, converting it to the format of your destination. This process runs after your sync and may take a long time if you have a large amount of data synced. Deleting data from these tables could potentially disrupt this process and lead to data loss or inconsistencies. It's generally recommended to leave these tables as they are unless you have a specific reason to modify them and understand the potential consequences. If you don't enable Basic Normalization, you'll have to transform the JSON data from that column yourself. So, if you're comfortable with handling the data transformation and understand the structure of your data, you could potentially delete data from these tables. However, it's important to be cautious and ensure you have backups or recovery plans in place. For more details, you can refer to the [Airbyte documentation](https://docs.airbyte.com/understanding-airbyte/basic-normalization) and [tutorials](https://airbyte.com/tutorials/full-data-synchronization).