Skip to content

/AWS1/IF_QST=>CREATEDATASET()

About CreateDataSet

Creates a dataset. This operation doesn't support datasets that include uploaded files as a source.

Method Signature

IMPORTING

Required arguments:

iv_awsaccountid TYPE /AWS1/QSTAWSACCOUNTID /AWS1/QSTAWSACCOUNTID

The Amazon Web Services account ID.

iv_datasetid TYPE /AWS1/QSTRESOURCEID /AWS1/QSTRESOURCEID

An ID for the dataset that you want to create. This ID is unique per Amazon Web Services Region for each Amazon Web Services account.

iv_name TYPE /AWS1/QSTRESOURCENAME /AWS1/QSTRESOURCENAME

The display name for the dataset.

it_physicaltablemap TYPE /AWS1/CL_QSTPHYSICALTABLE=>TT_PHYSICALTABLEMAP TT_PHYSICALTABLEMAP

Declares the physical tables that are available in the underlying data sources.

iv_importmode TYPE /AWS1/QSTDATASETIMPORTMODE /AWS1/QSTDATASETIMPORTMODE

Indicates whether you want to import the data into SPICE.

Optional arguments:

it_logicaltablemap TYPE /AWS1/CL_QSTLOGICALTABLE=>TT_LOGICALTABLEMAP TT_LOGICALTABLEMAP

Configures the combination and transformation of the data from the physical tables.

it_columngroups TYPE /AWS1/CL_QSTCOLUMNGROUP=>TT_COLUMNGROUPLIST TT_COLUMNGROUPLIST

Groupings of columns that work together in certain QuickSight features. Currently, only geospatial hierarchy is supported.

it_fieldfolders TYPE /AWS1/CL_QSTFIELDFOLDER=>TT_FIELDFOLDERMAP TT_FIELDFOLDERMAP

The folder that contains fields and nested subfolders for your dataset.

it_permissions TYPE /AWS1/CL_QSTRESOURCEPERMISSION=>TT_RESOURCEPERMISSIONLIST TT_RESOURCEPERMISSIONLIST

A list of resource permissions on the dataset.

io_rowlevelpermissiondataset TYPE REF TO /AWS1/CL_QSTROWLEVELPERMDS /AWS1/CL_QSTROWLEVELPERMDS

The row-level security configuration for the data that you want to create.

io_rowlevelpermissiontagconf TYPE REF TO /AWS1/CL_QSTROWLEVELPERMTAGC00 /AWS1/CL_QSTROWLEVELPERMTAGC00

The configuration of tags on a dataset to set row-level security. Row-level security tags are currently supported for anonymous embedding only.

it_columnlevelpermrules TYPE /AWS1/CL_QSTCOLUMNLEVELPERMRL=>TT_COLUMNLEVELPERMRULELIST TT_COLUMNLEVELPERMRULELIST

A set of one or more definitions of a ColumnLevelPermissionRule .

it_tags TYPE /AWS1/CL_QSTTAG=>TT_TAGLIST TT_TAGLIST

Contains a map of the key-value pairs for the resource tag or tags assigned to the dataset.

io_datasetusageconfiguration TYPE REF TO /AWS1/CL_QSTDATASETUSAGECONF /AWS1/CL_QSTDATASETUSAGECONF

DataSetUsageConfiguration

it_datasetparameters TYPE /AWS1/CL_QSTDATASETPARAMETER=>TT_DATASETPARAMETERLIST TT_DATASETPARAMETERLIST

The parameter declarations of the dataset.

it_folderarns TYPE /AWS1/CL_QSTFOLDERARNLIST_W=>TT_FOLDERARNLIST TT_FOLDERARNLIST

When you create the dataset, QuickSight adds the dataset to these folders.

io_performanceconfiguration TYPE REF TO /AWS1/CL_QSTPERFORMANCECONF /AWS1/CL_QSTPERFORMANCECONF

The configuration for the performance optimization of the dataset that contains a UniqueKey configuration.

iv_useas TYPE /AWS1/QSTDATASETUSEAS /AWS1/QSTDATASETUSEAS

The usage of the dataset. RLS_RULES must be specified for RLS permission datasets.

RETURNING

oo_output TYPE REF TO /aws1/cl_qstcreatedatasetrsp /AWS1/CL_QSTCREATEDATASETRSP

Domain /AWS1/RT_ACCOUNT_ID
Primitive Type NUMC

Examples

Syntax Example

This is an example of the syntax for calling the method. It includes every possible argument and initializes every possible value. The data provided is not necessarily semantically accurate (for example the value "string" may be provided for something that is intended to be an instance ID, or in some cases two arguments may be mutually exclusive). The syntax shows the ABAP syntax for creating the various data structures.

DATA(lo_result) = lo_client->/aws1/if_qst~createdataset(
  io_datasetusageconfiguration = new /aws1/cl_qstdatasetusageconf(
    iv_dsbuseasdirectquerysource = ABAP_TRUE
    iv_dsbuseasimportedsource = ABAP_TRUE
  )
  io_performanceconfiguration = new /aws1/cl_qstperformanceconf(
    it_uniquekeys = VALUE /aws1/cl_qstuniquekey=>tt_uniquekeylist(
      (
        new /aws1/cl_qstuniquekey(
          it_columnnames = VALUE /aws1/cl_qstuniquekeycolumnn00=>tt_uniquekeycolumnnamelist(
            ( new /aws1/cl_qstuniquekeycolumnn00( |string| ) )
          )
        )
      )
    )
  )
  io_rowlevelpermissiondataset = new /aws1/cl_qstrowlevelpermds(
    iv_arn = |string|
    iv_formatversion = |string|
    iv_namespace = |string|
    iv_permissionpolicy = |string|
    iv_status = |string|
  )
  io_rowlevelpermissiontagconf = new /aws1/cl_qstrowlevelpermtagc00(
    it_tagruleconfigurations = VALUE /aws1/cl_qstrowlevelpermtagr00=>tt_rowlevelpermtagruleconflist(
      (
        VALUE /aws1/cl_qstrowlevelpermtagr00=>tt_rowlevelpermtagruleconf(
          ( new /aws1/cl_qstrowlevelpermtagr00( |string| ) )
        )
      )
    )
    it_tagrules = VALUE /aws1/cl_qstrowlevelpermtagrl=>tt_rowlevelpermtagrulelist(
      (
        new /aws1/cl_qstrowlevelpermtagrl(
          iv_columnname = |string|
          iv_matchallvalue = |string|
          iv_tagkey = |string|
          iv_tagmultivaluedelimiter = |string|
        )
      )
    )
    iv_status = |string|
  )
  it_columngroups = VALUE /aws1/cl_qstcolumngroup=>tt_columngrouplist(
    (
      new /aws1/cl_qstcolumngroup(
        io_geospatialcolumngroup = new /aws1/cl_qstgeospatialcolumngr(
          it_columns = VALUE /aws1/cl_qstcolumnlist_w=>tt_columnlist(
            ( new /aws1/cl_qstcolumnlist_w( |string| ) )
          )
          iv_countrycode = |string|
          iv_name = |string|
        )
      )
    )
  )
  it_columnlevelpermrules = VALUE /aws1/cl_qstcolumnlevelpermrl=>tt_columnlevelpermrulelist(
    (
      new /aws1/cl_qstcolumnlevelpermrl(
        it_columnnames = VALUE /aws1/cl_qstcolumnnamelist_w=>tt_columnnamelist(
          ( new /aws1/cl_qstcolumnnamelist_w( |string| ) )
        )
        it_principals = VALUE /aws1/cl_qstprincipallist_w=>tt_principallist(
          ( new /aws1/cl_qstprincipallist_w( |string| ) )
        )
      )
    )
  )
  it_datasetparameters = VALUE /aws1/cl_qstdatasetparameter=>tt_datasetparameterlist(
    (
      new /aws1/cl_qstdatasetparameter(
        io_datetimedatasetparameter = new /aws1/cl_qstdatetimedsparam(
          io_defaultvalues = new /aws1/cl_qstdatetimedsprmdef00(
            it_staticvalues = VALUE /aws1/cl_qstdatetimedsprmval00=>tt_datetimedsparamvaluelist(
              ( new /aws1/cl_qstdatetimedsprmval00( '20150101000000.0000000' ) )
            )
          )
          iv_id = |string|
          iv_name = |string|
          iv_timegranularity = |string|
          iv_valuetype = |string|
        )
        io_decimaldatasetparameter = new /aws1/cl_qstdecimaldsparam(
          io_defaultvalues = new /aws1/cl_qstdecimaldsprmdefv00(
            it_staticvalues = VALUE /aws1/cl_qstdecimaldsprmvall00=>tt_decimaldsparamvaluelist(
              ( new /aws1/cl_qstdecimaldsprmvall00( |0.1| ) )
            )
          )
          iv_id = |string|
          iv_name = |string|
          iv_valuetype = |string|
        )
        io_integerdatasetparameter = new /aws1/cl_qstintegerdsparam(
          io_defaultvalues = new /aws1/cl_qstintegerdsprmdefv00(
            it_staticvalues = VALUE /aws1/cl_qstintegerdsprmvall00=>tt_integerdsparamvaluelist(
              ( new /aws1/cl_qstintegerdsprmvall00( 123 ) )
            )
          )
          iv_id = |string|
          iv_name = |string|
          iv_valuetype = |string|
        )
        io_stringdatasetparameter = new /aws1/cl_qststringdatasetparam(
          io_defaultvalues = new /aws1/cl_qststrdsparamdefvals(
            it_staticvalues = VALUE /aws1/cl_qststrdsparamvallst_w=>tt_stringdatasetparamvaluelist(
              ( new /aws1/cl_qststrdsparamvallst_w( |string| ) )
            )
          )
          iv_id = |string|
          iv_name = |string|
          iv_valuetype = |string|
        )
      )
    )
  )
  it_fieldfolders = VALUE /aws1/cl_qstfieldfolder=>tt_fieldfoldermap(
    (
      VALUE /aws1/cl_qstfieldfolder=>ts_fieldfoldermap_maprow(
        key = |string|
        value = new /aws1/cl_qstfieldfolder(
          it_columns = VALUE /aws1/cl_qstfoldercolumnlist_w=>tt_foldercolumnlist(
            ( new /aws1/cl_qstfoldercolumnlist_w( |string| ) )
          )
          iv_description = |string|
        )
      )
    )
  )
  it_folderarns = VALUE /aws1/cl_qstfolderarnlist_w=>tt_folderarnlist(
    ( new /aws1/cl_qstfolderarnlist_w( |string| ) )
  )
  it_logicaltablemap = VALUE /aws1/cl_qstlogicaltable=>tt_logicaltablemap(
    (
      VALUE /aws1/cl_qstlogicaltable=>ts_logicaltablemap_maprow(
        key = |string|
        value = new /aws1/cl_qstlogicaltable(
          io_source = new /aws1/cl_qstlogicaltablesource(
            io_joininstruction = new /aws1/cl_qstjoininstruction(
              io_leftjoinkeyproperties = new /aws1/cl_qstjoinkeyproperties( ABAP_TRUE )
              io_rightjoinkeyproperties = new /aws1/cl_qstjoinkeyproperties( ABAP_TRUE )
              iv_leftoperand = |string|
              iv_onclause = |string|
              iv_rightoperand = |string|
              iv_type = |string|
            )
            iv_datasetarn = |string|
            iv_physicaltableid = |string|
          )
          it_datatransforms = VALUE /aws1/cl_qsttransformoperation=>tt_transformoperationlist(
            (
              new /aws1/cl_qsttransformoperation(
                io_castcolumntypeoperation = new /aws1/cl_qstcastcolumntypeop(
                  iv_columnname = |string|
                  iv_format = |string|
                  iv_newcolumntype = |string|
                  iv_subtype = |string|
                )
                io_createcolumnsoperation = new /aws1/cl_qstcreatecolumnsop(
                  it_columns = VALUE /aws1/cl_qstcalculatedcolumn=>tt_calculatedcolumnlist(
                    (
                      new /aws1/cl_qstcalculatedcolumn(
                        iv_columnid = |string|
                        iv_columnname = |string|
                        iv_expression = |string|
                      )
                    )
                  )
                )
                io_filteroperation = new /aws1/cl_qstfilteroperation( |string| )
                io_overridedatasetparamop = new /aws1/cl_qstoverridedsparamop(
                  io_newdefaultvalues = new /aws1/cl_qstnewdefaultvalues(
                    it_datetimestaticvalues = VALUE /aws1/cl_qstdatetimedsprmval00=>tt_datetimedsparamvaluelist(
                      ( new /aws1/cl_qstdatetimedsprmval00( '20150101000000.0000000' ) )
                    )
                    it_decimalstaticvalues = VALUE /aws1/cl_qstdecimaldsprmvall00=>tt_decimaldsparamvaluelist(
                      ( new /aws1/cl_qstdecimaldsprmvall00( |0.1| ) )
                    )
                    it_integerstaticvalues = VALUE /aws1/cl_qstintegerdsprmvall00=>tt_integerdsparamvaluelist(
                      ( new /aws1/cl_qstintegerdsprmvall00( 123 ) )
                    )
                    it_stringstaticvalues = VALUE /aws1/cl_qststrdsparamvallst_w=>tt_stringdatasetparamvaluelist(
                      ( new /aws1/cl_qststrdsparamvallst_w( |string| ) )
                    )
                  )
                  iv_newparametername = |string|
                  iv_parametername = |string|
                )
                io_projectoperation = new /aws1/cl_qstprojectoperation(
                  it_projectedcolumns = VALUE /aws1/cl_qstprojectedcolumnl00=>tt_projectedcolumnlist(
                    ( new /aws1/cl_qstprojectedcolumnl00( |string| ) )
                  )
                )
                io_renamecolumnoperation = new /aws1/cl_qstrenamecolumnop(
                  iv_columnname = |string|
                  iv_newcolumnname = |string|
                )
                io_tagcolumnoperation = new /aws1/cl_qsttagcolumnoperation(
                  it_tags = VALUE /aws1/cl_qstcolumntag=>tt_columntaglist(
                    (
                      new /aws1/cl_qstcolumntag(
                        io_columndescription = new /aws1/cl_qstcolumndescription( |string| )
                        iv_columngeographicrole = |string|
                      )
                    )
                  )
                  iv_columnname = |string|
                )
                io_untagcolumnoperation = new /aws1/cl_qstuntagcolumnop(
                  it_tagnames = VALUE /aws1/cl_qstcolumntagnames_w=>tt_columntagnames(
                    ( new /aws1/cl_qstcolumntagnames_w( |string| ) )
                  )
                  iv_columnname = |string|
                )
              )
            )
          )
          iv_alias = |string|
        )
      )
    )
  )
  it_permissions = VALUE /aws1/cl_qstresourcepermission=>tt_resourcepermissionlist(
    (
      new /aws1/cl_qstresourcepermission(
        it_actions = VALUE /aws1/cl_qstactionlist_w=>tt_actionlist(
          ( new /aws1/cl_qstactionlist_w( |string| ) )
        )
        iv_principal = |string|
      )
    )
  )
  it_physicaltablemap = VALUE /aws1/cl_qstphysicaltable=>tt_physicaltablemap(
    (
      VALUE /aws1/cl_qstphysicaltable=>ts_physicaltablemap_maprow(
        value = new /aws1/cl_qstphysicaltable(
          io_customsql = new /aws1/cl_qstcustomsql(
            it_columns = VALUE /aws1/cl_qstinputcolumn=>tt_inputcolumnlist(
              (
                new /aws1/cl_qstinputcolumn(
                  iv_name = |string|
                  iv_subtype = |string|
                  iv_type = |string|
                )
              )
            )
            iv_datasourcearn = |string|
            iv_name = |string|
            iv_sqlquery = |string|
          )
          io_relationaltable = new /aws1/cl_qstrelationaltable(
            it_inputcolumns = VALUE /aws1/cl_qstinputcolumn=>tt_inputcolumnlist(
              (
                new /aws1/cl_qstinputcolumn(
                  iv_name = |string|
                  iv_subtype = |string|
                  iv_type = |string|
                )
              )
            )
            iv_catalog = |string|
            iv_datasourcearn = |string|
            iv_name = |string|
            iv_schema = |string|
          )
          io_s3source = new /aws1/cl_qsts3source(
            io_uploadsettings = new /aws1/cl_qstuploadsettings(
              iv_containsheader = ABAP_TRUE
              iv_delimiter = |string|
              iv_format = |string|
              iv_startfromrow = 123
              iv_textqualifier = |string|
            )
            it_inputcolumns = VALUE /aws1/cl_qstinputcolumn=>tt_inputcolumnlist(
              (
                new /aws1/cl_qstinputcolumn(
                  iv_name = |string|
                  iv_subtype = |string|
                  iv_type = |string|
                )
              )
            )
            iv_datasourcearn = |string|
          )
        )
        key = |string|
      )
    )
  )
  it_tags = VALUE /aws1/cl_qsttag=>tt_taglist(
    (
      new /aws1/cl_qsttag(
        iv_key = |string|
        iv_value = |string|
      )
    )
  )
  iv_awsaccountid = |string|
  iv_datasetid = |string|
  iv_importmode = |string|
  iv_name = |string|
  iv_useas = |string|
).

This is an example of reading all possible response values

lo_result = lo_result.
IF lo_result IS NOT INITIAL.
  lv_arn = lo_result->get_arn( ).
  lv_resourceid = lo_result->get_datasetid( ).
  lv_arn = lo_result->get_ingestionarn( ).
  lv_resourceid = lo_result->get_ingestionid( ).
  lv_string = lo_result->get_requestid( ).
  lv_statuscode = lo_result->get_status( ).
ENDIF.