How to Schedule a Pipeline in Snowflake Snowflake offers an effective method for automating and scheduling data pipelines through the use of Tasks. These tasks enable the scheduling of SQL…
Read MoreThis blog provides a step-by-step guide to setting up a Snowflake environment for loading data from AWS S3. Prerequisites: Snowflake Account-> Ensure you have access to a Snowflake account. AWS…
Read MoreIntroduction: The document outlines the procedures for performing backup and restoration of SQL Server databases using PowerShell. These processes ensure data safety, recovery readiness, and business continuity. Proper execution…
Read MoreIntroduction; The Data Migration Assistant (DMA) tool is a Microsoft utility designed to simplify the migration of databases from older SQL Server versions or on-premises environments to newer versions or…
Read MoreIntroduction: The user is experiencing a high CPU usage spike on their SQL Server instance, leading to performance degradation. The objective is to identify the root cause of the CPU…
Read MoreIntroduction: The user has reported a sudden memory usage spike on their SQL Server instance, resulting in degraded performance. You need to troubleshoot and identify the root cause of the…
Read MoreIntroduction/Issue:While working with Docker containers in our environment, we encountered an issue where certain containers were failing to start, throwing cryptic error messages. This disrupted the workflow and required immediate…
Read MoreIntroduction/Issue:During a period of increased traffic, our application faced performance bottlenecks due to insufficient resources. Manual intervention for scaling was inefficient, so we decided to implement auto-scaling for our Kubernetes…
Read MoreSELECT dha.source_order_number, dha.order_number, dfla.status_code, dfla.source_line_number FROM fusion.doo_headers_all dha, fusion.doo_fulfill_lines_all dfla, fusion.wsh_delivery_assignments wda, fusion.wsh_new_deliveries wnd, fusion.wsh_delivery_details wdd, fusion.inv_material_txns imt WHERE dha.header_id=dfla.header_id AND dfla.fulfill_line_id=wdd.source_shipment_id AND wdd.delivery_detail_id=wda.delivery_detail_id AND wda.delivery_id=wnd.delivery_id(+)…
Read MoreSELECT esi.inventory_item_id, esi.item_number, esi.organization_id, inv.organization_code, esi.enabled_flag, esi.end_date_active, ohq.transaction_quantity onhand_qty FROM fusion.egp_system_items_b esi, fusion.inv_org_parameters inv, fusion.inv_onhand_quantities_detail ohq WHERE inv.organization_id=esi.organization_id AND inv.organization_id=ohq.organization_id AND esi.inventory_item_id=ohq.inventory_item_id
Read More