none
Azure Data Factory - Dataset - Could not Load resource error when updating JSON code

    Question

  • Azure Data Factory - new Dataset creation - 'Could not Load resource' when updating JSON code

    I am unable to override the json code when creating a dataset in Azure Data Factory V2.  I try to hit finish and get 'Could not load resource' error.

    I get this error on any JSON code that I try to save

    {
      "name": "usql_amazonactualsalesmaster",
      "properties": {
        "structure": [
          {
            "name": "Asin",
            "type": "String"
          },
          {
            "name": "Sku",
            "type": "String"
          },
          {
            "name": "Ordered_Revenue",
            "type": "Decimal"
          },
          {
            "name": "Ordered_Units",
            "type": "Int16"
          },
          {
            "name": "Sales_Date",
            "type": "DateTime"
          }
        ],
        "published": false,
        "type": "AzureBlob",
        "linkedServiceName": "AzureBlobLinkedService1",
        "typeProperties": {
          "folderPath": "lfanalytics/output/",
          "fileName": "actualsalesmaster.csv",
          "format": {
            "type": "TextFormat",
            "columnDelimiter": ",",
            "firstRowAsHeader": true
          },
          "availability": {
            "frequency": "Day",
            "interval": 1
          }
        }
      }
    }

    Thursday, November 8, 2018 9:17 PM

All replies

  • Hi,

      The format of linkedservie name property should be like:
    "linkedServiceName": {
                "referenceName": "AzureBlobLinkedService1",
                "type": "LinkedServiceReference"
      }

    Thanks,

    Li

    Friday, November 9, 2018 4:57 AM
  • Hi,

    In addition to what Li suggested, some properties including "availability" have been deprecated in Azure Data Factory V2.

    Please refer to the new JSON format for Datasets in the documentation for V2 by following this link :

    https://docs.microsoft.com/en-us/azure/data-factory/concepts-datasets-linked-services#dataset-json
    Friday, November 9, 2018 7:17 AM
  • Thank-you for the feedback..  Yes this was definitely my issue.   I was using sample from the MS EDX course that I took on Azure Data Factory - which was all V1 formats
    Friday, November 9, 2018 9:10 PM