meetchandan

x-ab-test:
1881,2281,2851,3411,2571,3251,1471,1931,2042,551,3081,3401,1711,2361,2141,2933,1481,1371,1891,2391,3101,3112
x-addresscode:
6c4402c5021ae163072ec32b6e65c70b
x-addresskey:
6c4402c5021ae163072ec32b6e65c70b-1
x-border-enabled:
true
x-build:
15713

meetchandan

[[dags]]
dag_id = 'instock_chatbot'
schedule_interval = '0 */4 * * *'
failure_email_list = ['cbhattad@noon.com']

[[custom-bqtoch]]
dag_id = 'instock_chatbot'
task_id = 'sku_metadata'
ch_cluster = "mxtech"
ch_db = "instock"

meetchandan

Instock AI Assistant

You are an AI assistant for the Instock team at Noon to help with analysis and insights.

Your Role

Help team members with data analysis, reporting, and decision-making.

Guidelines

meetchandan

You are a data analyst tool for analyzing Noon Minutes advertising data.

Communication Style

• NEVER introduce yourself or explain what you are
• NEVER mention being a "tool", "agent", or "data analyst"
• Just provide the requested information directly

meetchandan

{
  "exref": {
    "exref_type_code": "mp_instant_order",
    "mp_code": "nooninstant",
    "external_ref": "ISAG2F719U3SQYGYPA"
  },
  "lines": [
    {
      "entity_from": "entity::partner::sa::9311",
      "entity_to": "entity::customer_address::sa::c4d4bbcce048d2efe5bf9bed8715633f::2",

meetchandan

{
  "exref": {
    "exref_type_code": "mp_instant_order",
    "mp_code": "nooninstant",
    "external_ref": "IBHG2D6BHLAH2PZOVA"
  },
  "lines": [
    {
      "entity_from": "entity::legal_entity_v2::bh::LE35L4ESNBH",
      "entity_to": "entity::customer_address::bh::91cf0b5159fe39aae8a5eb7981766eea::1",

meetchandan

{
  "exref": {
    "exref_type_code": "mp_instant_order",
    "mp_code": "nooninstant",
    "external_ref": "IBHG244BHLE24GU0LA"
  },
  "lines": [
    {
      "entity_from": "entity::legal_entity_v2::bh::LE35L4ESNBH",
      "entity_to": "entity::customer_address::bh::1292252d5aeb82aa526df4aa5a564efd::1",

meetchandan

{
  "exref": {
    "exref_type_code": "mp_instant_order",
    "mp_code": "nooninstant",
    "external_ref": "IBHG244BHLE24GU0LA"
  },
  "lines": [
    {
      "entity_from": "entity::partner::bh::451558",
      "entity_to": "entity::customer_address::bh::1292252d5aeb82aa526df4aa5a564efd::1",

meetchandan

update customer_address
set is_deleted = 1
where address_code in ("596f1496cc3866847bd9607efdde1516","e9362f5b9585e9869b78575d6fda720d","f2f31bcc7e529e43f41d30e9f5ddd97b","c97b82645a8642b00d20681e4b6a210c","d15f71e30537cc5f34f9440b8c606413","bf154e63d47ed6689a63f154f079b6dd","3aa44019ac2fbf439e8c3bb37ceb8932","21617112c6daebc9854e51322270e0e8","90ca2b8e62b54fca27a4244d07d9cfca","fdcd24b356b4361948a6f7e3cec06bc8","fcfca590f647faf2bcd589be651fdd62","829b82f962d40c7fb8901b08c9506667","0dde17de941a7d44886cdb898cfad03d","d591ae719ae87016470b6107251a17d9","48963713aa812b0556b7e25bcc12ca91","7b4380a0b7c039fbb7508f5f96ea1967","c70f127851b422251ba86964f54c255a","5e2e89f2306cf83be7be40b8b25a5ff7","09e6d50d45bae0971ce0cdda79a874c0","dc5f52223f6921a2b5e98acc312d1cd5","d5bcbb37b3d4f01a23f2412290ecb7d9","11b799628ad5fc636d70fd611c3e418c","16276a239a48250b4e1ce007d4a731b3","219a1abd34b235794b5e627a43c580ea","0a0dc8290fc56ebc45fe15b919207512","21f817a14cf01d81e679e216ba7e565b","5e7e857d46d7abb320f8e49f2229c9a6","b7e9dd36fe1e

meetchandan

{
    "nbHits": 1,
    "nbPages": 1,
    "search": {
        "q": null,
        "sort": null,
        "f": {
            "page_code": [
                "home_app_mobile_ae_v2"
            ]