Query

id: fabric_warehouse_query
namespace: company.team

tasks:
  - id: query
    type: io.kestra.plugin.microsoft.fabric.warehouse.Query
    tenantId: "{{ secret('FABRIC_TENANT_ID') }}"
    clientId: "{{ secret('FABRIC_CLIENT_ID') }}"
    clientSecret: "{{ secret('FABRIC_CLIENT_SECRET') }}"
    sqlEndpointId: "your-sql-endpoint-id"
    warehouseId: "your-warehouse-id"
    sql: "SELECT TOP 100 * FROM dbo.sales"
    fetchType: STORE