Is it possible to insert data into fabric datawarehouse using a script that isnt in fabric notebook?

Hi eduardo_schmitz ,

Thank you for reaching out in Microsoft Fabric Community.
Based on your scenario, there are multiple ways to ingest data from AWS into Microsoft Fabric Data Warehouse:

1. Direct Data Ingestion from AWS
You can establish a connection from AWS services (such as AWS Lambda, AWS Glue) to Fabric Data Warehouse using ODBC/JDBC. This allows data to be inserted directly into Fabric DW using INSERT INTO or MERGE statements. However, setting up and maintaining the connection falls under AWS configurations.

2. Using Fabric Data Pipelines.
Microsoft Fabric offers Data Pipelines to ingest data from AWS S3 using Fabric's S3 connector.
This method enables a no-code/low-code approach to move data into Fabric Data Warehouse efficiently.
Set up your Amazon S3 connection - Microsoft Fabric | Microsoft Learn

Since setting up a direct connection from AWS to Fabric DW primarily involves AWS-side configurations, I recommend posting this in the AWS Community Forum for more insights from AWS experts:
  AWS re:Post Community → https://repost.aws/

Hope this helps. Please reach out for further assistance.

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly and a kudos would be appreciated.

Best Regards,
Vinay.

Hi eduardo_schmitz ,
Thanks for the update,
To help you get started with ODBC/JDBC connections to Fabric Data Warehouse, here are some useful resources:

1. Connectivity to data warehousing - Microsoft Fabric | Microsoft Learn

2. Set up your Odbc connection - Microsoft Fabric | Microsoft Learn

3. Microsoft ODBC Driver for SQL Server - ODBC Driver for SQL Server | Microsoft Learn

4. Microsoft JDBC Driver for SQL Server - JDBC Driver for SQL Server | Microsoft Learn

If you're considering Fabric's REST API as an alternative, you can explore:
Microsoft Fabric REST API references - Microsoft Fabric REST APIs | Microsoft Learn

Hope these help. Please reach out for further assistance.

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly and a kudos would be appreciated.

Thank you.