flexibleengine.DliTable
Explore with Pulumi AI
Manages DLI Table resource within FlexibleEngine
Example Usage
Create a Table
import * as pulumi from "@pulumi/pulumi";
import * as flexibleengine from "@pulumi/flexibleengine";
const config = new pulumi.Config();
const databaseName = config.requireObject("databaseName");
const testDliDatabase = new flexibleengine.DliDatabase("testDliDatabase", {});
const testObsBucket = new flexibleengine.ObsBucket("testObsBucket", {
bucket: "test",
acl: "private",
});
const testObsBucketObject = new flexibleengine.ObsBucketObject("testObsBucketObject", {
bucket: testObsBucket.bucket,
key: "user/data/user.csv",
content: "Jason,Tokyo",
contentType: "text/plain",
});
const testDliTable = new flexibleengine.DliTable("testDliTable", {
databaseName: testDliDatabase.name,
dataLocation: "OBS",
description: "dli table test",
dataFormat: "csv",
bucketLocation: pulumi.interpolate`obs://${testObsBucketObject.bucket}/user/data`,
columns: [
{
name: "name",
type: "string",
description: "person name",
},
{
name: "addrss",
type: "string",
description: "home address",
},
],
});
import pulumi
import pulumi_flexibleengine as flexibleengine
config = pulumi.Config()
database_name = config.require_object("databaseName")
test_dli_database = flexibleengine.DliDatabase("testDliDatabase")
test_obs_bucket = flexibleengine.ObsBucket("testObsBucket",
bucket="test",
acl="private")
test_obs_bucket_object = flexibleengine.ObsBucketObject("testObsBucketObject",
bucket=test_obs_bucket.bucket,
key="user/data/user.csv",
content="Jason,Tokyo",
content_type="text/plain")
test_dli_table = flexibleengine.DliTable("testDliTable",
database_name=test_dli_database.name,
data_location="OBS",
description="dli table test",
data_format="csv",
bucket_location=test_obs_bucket_object.bucket.apply(lambda bucket: f"obs://{bucket}/user/data"),
columns=[
{
"name": "name",
"type": "string",
"description": "person name",
},
{
"name": "addrss",
"type": "string",
"description": "home address",
},
])
package main
import (
"fmt"
"github.com/pulumi/pulumi-terraform-provider/sdks/go/flexibleengine/flexibleengine"
"github.com/pulumi/pulumi/sdk/v3/go/pulumi"
"github.com/pulumi/pulumi/sdk/v3/go/pulumi/config"
)
func main() {
pulumi.Run(func(ctx *pulumi.Context) error {
cfg := config.New(ctx, "")
databaseName := cfg.RequireObject("databaseName")
testDliDatabase, err := flexibleengine.NewDliDatabase(ctx, "testDliDatabase", nil)
if err != nil {
return err
}
testObsBucket, err := flexibleengine.NewObsBucket(ctx, "testObsBucket", &flexibleengine.ObsBucketArgs{
Bucket: pulumi.String("test"),
Acl: pulumi.String("private"),
})
if err != nil {
return err
}
testObsBucketObject, err := flexibleengine.NewObsBucketObject(ctx, "testObsBucketObject", &flexibleengine.ObsBucketObjectArgs{
Bucket: testObsBucket.Bucket,
Key: pulumi.String("user/data/user.csv"),
Content: pulumi.String("Jason,Tokyo"),
ContentType: pulumi.String("text/plain"),
})
if err != nil {
return err
}
_, err = flexibleengine.NewDliTable(ctx, "testDliTable", &flexibleengine.DliTableArgs{
DatabaseName: testDliDatabase.Name,
DataLocation: pulumi.String("OBS"),
Description: pulumi.String("dli table test"),
DataFormat: pulumi.String("csv"),
BucketLocation: testObsBucketObject.Bucket.ApplyT(func(bucket string) (string, error) {
return fmt.Sprintf("obs://%v/user/data", bucket), nil
}).(pulumi.StringOutput),
Columns: flexibleengine.DliTableColumnArray{
&flexibleengine.DliTableColumnArgs{
Name: pulumi.String("name"),
Type: pulumi.String("string"),
Description: pulumi.String("person name"),
},
&flexibleengine.DliTableColumnArgs{
Name: pulumi.String("addrss"),
Type: pulumi.String("string"),
Description: pulumi.String("home address"),
},
},
})
if err != nil {
return err
}
return nil
})
}
using System.Collections.Generic;
using System.Linq;
using Pulumi;
using Flexibleengine = Pulumi.Flexibleengine;
return await Deployment.RunAsync(() =>
{
var config = new Config();
var databaseName = config.RequireObject<dynamic>("databaseName");
var testDliDatabase = new Flexibleengine.DliDatabase("testDliDatabase");
var testObsBucket = new Flexibleengine.ObsBucket("testObsBucket", new()
{
Bucket = "test",
Acl = "private",
});
var testObsBucketObject = new Flexibleengine.ObsBucketObject("testObsBucketObject", new()
{
Bucket = testObsBucket.Bucket,
Key = "user/data/user.csv",
Content = "Jason,Tokyo",
ContentType = "text/plain",
});
var testDliTable = new Flexibleengine.DliTable("testDliTable", new()
{
DatabaseName = testDliDatabase.Name,
DataLocation = "OBS",
Description = "dli table test",
DataFormat = "csv",
BucketLocation = testObsBucketObject.Bucket.Apply(bucket => $"obs://{bucket}/user/data"),
Columns = new[]
{
new Flexibleengine.Inputs.DliTableColumnArgs
{
Name = "name",
Type = "string",
Description = "person name",
},
new Flexibleengine.Inputs.DliTableColumnArgs
{
Name = "addrss",
Type = "string",
Description = "home address",
},
},
});
});
package generated_program;
import com.pulumi.Context;
import com.pulumi.Pulumi;
import com.pulumi.core.Output;
import com.pulumi.flexibleengine.DliDatabase;
import com.pulumi.flexibleengine.ObsBucket;
import com.pulumi.flexibleengine.ObsBucketArgs;
import com.pulumi.flexibleengine.ObsBucketObject;
import com.pulumi.flexibleengine.ObsBucketObjectArgs;
import com.pulumi.flexibleengine.DliTable;
import com.pulumi.flexibleengine.DliTableArgs;
import com.pulumi.flexibleengine.inputs.DliTableColumnArgs;
import java.util.List;
import java.util.ArrayList;
import java.util.Map;
import java.io.File;
import java.nio.file.Files;
import java.nio.file.Paths;
public class App {
public static void main(String[] args) {
Pulumi.run(App::stack);
}
public static void stack(Context ctx) {
final var config = ctx.config();
final var databaseName = config.get("databaseName");
var testDliDatabase = new DliDatabase("testDliDatabase");
var testObsBucket = new ObsBucket("testObsBucket", ObsBucketArgs.builder()
.bucket("test")
.acl("private")
.build());
var testObsBucketObject = new ObsBucketObject("testObsBucketObject", ObsBucketObjectArgs.builder()
.bucket(testObsBucket.bucket())
.key("user/data/user.csv")
.content("Jason,Tokyo")
.contentType("text/plain")
.build());
var testDliTable = new DliTable("testDliTable", DliTableArgs.builder()
.databaseName(testDliDatabase.name())
.dataLocation("OBS")
.description("dli table test")
.dataFormat("csv")
.bucketLocation(testObsBucketObject.bucket().applyValue(bucket -> String.format("obs://%s/user/data", bucket)))
.columns(
DliTableColumnArgs.builder()
.name("name")
.type("string")
.description("person name")
.build(),
DliTableColumnArgs.builder()
.name("addrss")
.type("string")
.description("home address")
.build())
.build());
}
}
configuration:
databaseName:
type: dynamic
resources:
testDliDatabase:
type: flexibleengine:DliDatabase
testObsBucket:
type: flexibleengine:ObsBucket
properties:
bucket: test
acl: private
testObsBucketObject:
type: flexibleengine:ObsBucketObject
properties:
bucket: ${testObsBucket.bucket}
key: user/data/user.csv
content: Jason,Tokyo
contentType: text/plain
testDliTable:
type: flexibleengine:DliTable
properties:
databaseName: ${testDliDatabase.name}
dataLocation: OBS
description: dli table test
dataFormat: csv
bucketLocation: obs://${testObsBucketObject.bucket}/user/data
columns:
- name: name
type: string
description: person name
- name: addrss
type: string
description: home address
Create DliTable Resource
Resources are created with functions called constructors. To learn more about declaring and configuring resources, see Resources.
Constructor syntax
new DliTable(name: string, args: DliTableArgs, opts?: CustomResourceOptions);
@overload
def DliTable(resource_name: str,
args: DliTableArgs,
opts: Optional[ResourceOptions] = None)
@overload
def DliTable(resource_name: str,
opts: Optional[ResourceOptions] = None,
data_location: Optional[str] = None,
database_name: Optional[str] = None,
dli_table_id: Optional[str] = None,
escape_char: Optional[str] = None,
columns: Optional[Sequence[DliTableColumnArgs]] = None,
date_format: Optional[str] = None,
delimiter: Optional[str] = None,
description: Optional[str] = None,
bucket_location: Optional[str] = None,
data_format: Optional[str] = None,
name: Optional[str] = None,
quote_char: Optional[str] = None,
region: Optional[str] = None,
timeouts: Optional[DliTableTimeoutsArgs] = None,
timestamp_format: Optional[str] = None,
with_column_header: Optional[bool] = None)
func NewDliTable(ctx *Context, name string, args DliTableArgs, opts ...ResourceOption) (*DliTable, error)
public DliTable(string name, DliTableArgs args, CustomResourceOptions? opts = null)
public DliTable(String name, DliTableArgs args)
public DliTable(String name, DliTableArgs args, CustomResourceOptions options)
type: flexibleengine:DliTable
properties: # The arguments to resource properties.
options: # Bag of options to control resource's behavior.
Parameters
- name string
- The unique name of the resource.
- args DliTableArgs
- The arguments to resource properties.
- opts CustomResourceOptions
- Bag of options to control resource's behavior.
- resource_name str
- The unique name of the resource.
- args DliTableArgs
- The arguments to resource properties.
- opts ResourceOptions
- Bag of options to control resource's behavior.
- ctx Context
- Context object for the current deployment.
- name string
- The unique name of the resource.
- args DliTableArgs
- The arguments to resource properties.
- opts ResourceOption
- Bag of options to control resource's behavior.
- name string
- The unique name of the resource.
- args DliTableArgs
- The arguments to resource properties.
- opts CustomResourceOptions
- Bag of options to control resource's behavior.
- name String
- The unique name of the resource.
- args DliTableArgs
- The arguments to resource properties.
- options CustomResourceOptions
- Bag of options to control resource's behavior.
Constructor example
The following reference example uses placeholder values for all input properties.
var dliTableResource = new Flexibleengine.DliTable("dliTableResource", new()
{
DataLocation = "string",
DatabaseName = "string",
DliTableId = "string",
EscapeChar = "string",
Columns = new[]
{
new Flexibleengine.Inputs.DliTableColumnArgs
{
Name = "string",
Type = "string",
Description = "string",
IsPartition = false,
},
},
DateFormat = "string",
Delimiter = "string",
Description = "string",
BucketLocation = "string",
DataFormat = "string",
Name = "string",
QuoteChar = "string",
Region = "string",
Timeouts = new Flexibleengine.Inputs.DliTableTimeoutsArgs
{
Delete = "string",
},
TimestampFormat = "string",
WithColumnHeader = false,
});
example, err := flexibleengine.NewDliTable(ctx, "dliTableResource", &flexibleengine.DliTableArgs{
DataLocation: pulumi.String("string"),
DatabaseName: pulumi.String("string"),
DliTableId: pulumi.String("string"),
EscapeChar: pulumi.String("string"),
Columns: flexibleengine.DliTableColumnArray{
&flexibleengine.DliTableColumnArgs{
Name: pulumi.String("string"),
Type: pulumi.String("string"),
Description: pulumi.String("string"),
IsPartition: pulumi.Bool(false),
},
},
DateFormat: pulumi.String("string"),
Delimiter: pulumi.String("string"),
Description: pulumi.String("string"),
BucketLocation: pulumi.String("string"),
DataFormat: pulumi.String("string"),
Name: pulumi.String("string"),
QuoteChar: pulumi.String("string"),
Region: pulumi.String("string"),
Timeouts: &flexibleengine.DliTableTimeoutsArgs{
Delete: pulumi.String("string"),
},
TimestampFormat: pulumi.String("string"),
WithColumnHeader: pulumi.Bool(false),
})
var dliTableResource = new DliTable("dliTableResource", DliTableArgs.builder()
.dataLocation("string")
.databaseName("string")
.dliTableId("string")
.escapeChar("string")
.columns(DliTableColumnArgs.builder()
.name("string")
.type("string")
.description("string")
.isPartition(false)
.build())
.dateFormat("string")
.delimiter("string")
.description("string")
.bucketLocation("string")
.dataFormat("string")
.name("string")
.quoteChar("string")
.region("string")
.timeouts(DliTableTimeoutsArgs.builder()
.delete("string")
.build())
.timestampFormat("string")
.withColumnHeader(false)
.build());
dli_table_resource = flexibleengine.DliTable("dliTableResource",
data_location="string",
database_name="string",
dli_table_id="string",
escape_char="string",
columns=[{
"name": "string",
"type": "string",
"description": "string",
"is_partition": False,
}],
date_format="string",
delimiter="string",
description="string",
bucket_location="string",
data_format="string",
name="string",
quote_char="string",
region="string",
timeouts={
"delete": "string",
},
timestamp_format="string",
with_column_header=False)
const dliTableResource = new flexibleengine.DliTable("dliTableResource", {
dataLocation: "string",
databaseName: "string",
dliTableId: "string",
escapeChar: "string",
columns: [{
name: "string",
type: "string",
description: "string",
isPartition: false,
}],
dateFormat: "string",
delimiter: "string",
description: "string",
bucketLocation: "string",
dataFormat: "string",
name: "string",
quoteChar: "string",
region: "string",
timeouts: {
"delete": "string",
},
timestampFormat: "string",
withColumnHeader: false,
});
type: flexibleengine:DliTable
properties:
bucketLocation: string
columns:
- description: string
isPartition: false
name: string
type: string
dataFormat: string
dataLocation: string
databaseName: string
dateFormat: string
delimiter: string
description: string
dliTableId: string
escapeChar: string
name: string
quoteChar: string
region: string
timeouts:
delete: string
timestampFormat: string
withColumnHeader: false
DliTable Resource Properties
To learn more about resource properties and how to use them, see Inputs and Outputs in the Architecture and Concepts docs.
Inputs
In Python, inputs that are objects can be passed either as argument classes or as dictionary literals.
The DliTable resource accepts the following input properties:
- Data
Location string - Specifies data storage location. Changing this parameter will create
a newresource. The options are as follows:
- OBS: Data stored in OBS tables is applicable to delay-insensitive services, such as historical data statistics and analysis.
- Database
Name string - Specifies the database name which the table belongs to. Changing this parameter will create a new resource.
- Bucket
Location string Specifies storage path of data which will be import to the OBS table. Changing this parameter will create a new resource.
If you need to import data stored in OBS to the OBS table, set this parameter to the path of a folder. If the table creation path is a file, data fails to be imported. which must be a path on OBS and must begin with obs.
- Columns
List<Dli
Table Column> - Specifies Columns of the new table. Structure is documented below. Changing this parameter will create a new resource.
- Data
Format string - Specifies type of the data to be added to the OBS table. The options: parquet, orc, csv, json, carbon, and avro. Changing this parameter will create a new resource.
- Date
Format string - Specifies date type.
yyyy-MM-dd
is used by default. Only data in CSV and JSON files has this attribute. Changing this parameter will create a new resource. - Delimiter string
- Specifies data delimiter. Only data in CSV files has this attribute. Changing this parameter will create a new resource.
- Description string
- Specifies description of the table. Changing this parameter will create a new resource.
- Dli
Table stringId - A resource ID in format of database_name/table_name. It is composed of the name of database which table belongs and the name of table, separated by a slash.
- Escape
Char string - Specifies escape character. Backslashes (
\\
) are used by default. Only data in CSV files has this attribute. Changing this parameter will create a new resource. - Name string
- Specifies the table name. The name can contain only digits, letters, and underscores, but cannot contain only digits or start with an underscore. Length range: 1 to 128 characters. Changing this parameter will create a new resource.
- Quote
Char string - Specifies reference character. Double quotation marks (
\
) are used by default. Only data in CSV files has this attribute. Changing this parameter will create a new resource. - Region string
- Specifies the region in which to create the dli table resource. If omitted, the provider-level region will be used. Changing this parameter will create a new resource.
- Timeouts
Dli
Table Timeouts - Timestamp
Format string - Specifies timestamp type.
yyyy-MM-dd HH:mm:ss
is used by default. Only data in CSV and JSON files has this attribute. Changing this parameter will create a new resource. - With
Column boolHeader - Specifies whether the table header is included in the data file. Only data in CSV files has this attribute. Changing this parameter will create a new resource.
- Data
Location string - Specifies data storage location. Changing this parameter will create
a newresource. The options are as follows:
- OBS: Data stored in OBS tables is applicable to delay-insensitive services, such as historical data statistics and analysis.
- Database
Name string - Specifies the database name which the table belongs to. Changing this parameter will create a new resource.
- Bucket
Location string Specifies storage path of data which will be import to the OBS table. Changing this parameter will create a new resource.
If you need to import data stored in OBS to the OBS table, set this parameter to the path of a folder. If the table creation path is a file, data fails to be imported. which must be a path on OBS and must begin with obs.
- Columns
[]Dli
Table Column Args - Specifies Columns of the new table. Structure is documented below. Changing this parameter will create a new resource.
- Data
Format string - Specifies type of the data to be added to the OBS table. The options: parquet, orc, csv, json, carbon, and avro. Changing this parameter will create a new resource.
- Date
Format string - Specifies date type.
yyyy-MM-dd
is used by default. Only data in CSV and JSON files has this attribute. Changing this parameter will create a new resource. - Delimiter string
- Specifies data delimiter. Only data in CSV files has this attribute. Changing this parameter will create a new resource.
- Description string
- Specifies description of the table. Changing this parameter will create a new resource.
- Dli
Table stringId - A resource ID in format of database_name/table_name. It is composed of the name of database which table belongs and the name of table, separated by a slash.
- Escape
Char string - Specifies escape character. Backslashes (
\\
) are used by default. Only data in CSV files has this attribute. Changing this parameter will create a new resource. - Name string
- Specifies the table name. The name can contain only digits, letters, and underscores, but cannot contain only digits or start with an underscore. Length range: 1 to 128 characters. Changing this parameter will create a new resource.
- Quote
Char string - Specifies reference character. Double quotation marks (
\
) are used by default. Only data in CSV files has this attribute. Changing this parameter will create a new resource. - Region string
- Specifies the region in which to create the dli table resource. If omitted, the provider-level region will be used. Changing this parameter will create a new resource.
- Timeouts
Dli
Table Timeouts Args - Timestamp
Format string - Specifies timestamp type.
yyyy-MM-dd HH:mm:ss
is used by default. Only data in CSV and JSON files has this attribute. Changing this parameter will create a new resource. - With
Column boolHeader - Specifies whether the table header is included in the data file. Only data in CSV files has this attribute. Changing this parameter will create a new resource.
- data
Location String - Specifies data storage location. Changing this parameter will create
a newresource. The options are as follows:
- OBS: Data stored in OBS tables is applicable to delay-insensitive services, such as historical data statistics and analysis.
- database
Name String - Specifies the database name which the table belongs to. Changing this parameter will create a new resource.
- bucket
Location String Specifies storage path of data which will be import to the OBS table. Changing this parameter will create a new resource.
If you need to import data stored in OBS to the OBS table, set this parameter to the path of a folder. If the table creation path is a file, data fails to be imported. which must be a path on OBS and must begin with obs.
- columns
List<Dli
Table Column> - Specifies Columns of the new table. Structure is documented below. Changing this parameter will create a new resource.
- data
Format String - Specifies type of the data to be added to the OBS table. The options: parquet, orc, csv, json, carbon, and avro. Changing this parameter will create a new resource.
- date
Format String - Specifies date type.
yyyy-MM-dd
is used by default. Only data in CSV and JSON files has this attribute. Changing this parameter will create a new resource. - delimiter String
- Specifies data delimiter. Only data in CSV files has this attribute. Changing this parameter will create a new resource.
- description String
- Specifies description of the table. Changing this parameter will create a new resource.
- dli
Table StringId - A resource ID in format of database_name/table_name. It is composed of the name of database which table belongs and the name of table, separated by a slash.
- escape
Char String - Specifies escape character. Backslashes (
\\
) are used by default. Only data in CSV files has this attribute. Changing this parameter will create a new resource. - name String
- Specifies the table name. The name can contain only digits, letters, and underscores, but cannot contain only digits or start with an underscore. Length range: 1 to 128 characters. Changing this parameter will create a new resource.
- quote
Char String - Specifies reference character. Double quotation marks (
\
) are used by default. Only data in CSV files has this attribute. Changing this parameter will create a new resource. - region String
- Specifies the region in which to create the dli table resource. If omitted, the provider-level region will be used. Changing this parameter will create a new resource.
- timeouts
Dli
Table Timeouts - timestamp
Format String - Specifies timestamp type.
yyyy-MM-dd HH:mm:ss
is used by default. Only data in CSV and JSON files has this attribute. Changing this parameter will create a new resource. - with
Column BooleanHeader - Specifies whether the table header is included in the data file. Only data in CSV files has this attribute. Changing this parameter will create a new resource.
- data
Location string - Specifies data storage location. Changing this parameter will create
a newresource. The options are as follows:
- OBS: Data stored in OBS tables is applicable to delay-insensitive services, such as historical data statistics and analysis.
- database
Name string - Specifies the database name which the table belongs to. Changing this parameter will create a new resource.
- bucket
Location string Specifies storage path of data which will be import to the OBS table. Changing this parameter will create a new resource.
If you need to import data stored in OBS to the OBS table, set this parameter to the path of a folder. If the table creation path is a file, data fails to be imported. which must be a path on OBS and must begin with obs.
- columns
Dli
Table Column[] - Specifies Columns of the new table. Structure is documented below. Changing this parameter will create a new resource.
- data
Format string - Specifies type of the data to be added to the OBS table. The options: parquet, orc, csv, json, carbon, and avro. Changing this parameter will create a new resource.
- date
Format string - Specifies date type.
yyyy-MM-dd
is used by default. Only data in CSV and JSON files has this attribute. Changing this parameter will create a new resource. - delimiter string
- Specifies data delimiter. Only data in CSV files has this attribute. Changing this parameter will create a new resource.
- description string
- Specifies description of the table. Changing this parameter will create a new resource.
- dli
Table stringId - A resource ID in format of database_name/table_name. It is composed of the name of database which table belongs and the name of table, separated by a slash.
- escape
Char string - Specifies escape character. Backslashes (
\\
) are used by default. Only data in CSV files has this attribute. Changing this parameter will create a new resource. - name string
- Specifies the table name. The name can contain only digits, letters, and underscores, but cannot contain only digits or start with an underscore. Length range: 1 to 128 characters. Changing this parameter will create a new resource.
- quote
Char string - Specifies reference character. Double quotation marks (
\
) are used by default. Only data in CSV files has this attribute. Changing this parameter will create a new resource. - region string
- Specifies the region in which to create the dli table resource. If omitted, the provider-level region will be used. Changing this parameter will create a new resource.
- timeouts
Dli
Table Timeouts - timestamp
Format string - Specifies timestamp type.
yyyy-MM-dd HH:mm:ss
is used by default. Only data in CSV and JSON files has this attribute. Changing this parameter will create a new resource. - with
Column booleanHeader - Specifies whether the table header is included in the data file. Only data in CSV files has this attribute. Changing this parameter will create a new resource.
- data_
location str - Specifies data storage location. Changing this parameter will create
a newresource. The options are as follows:
- OBS: Data stored in OBS tables is applicable to delay-insensitive services, such as historical data statistics and analysis.
- database_
name str - Specifies the database name which the table belongs to. Changing this parameter will create a new resource.
- bucket_
location str Specifies storage path of data which will be import to the OBS table. Changing this parameter will create a new resource.
If you need to import data stored in OBS to the OBS table, set this parameter to the path of a folder. If the table creation path is a file, data fails to be imported. which must be a path on OBS and must begin with obs.
- columns
Sequence[Dli
Table Column Args] - Specifies Columns of the new table. Structure is documented below. Changing this parameter will create a new resource.
- data_
format str - Specifies type of the data to be added to the OBS table. The options: parquet, orc, csv, json, carbon, and avro. Changing this parameter will create a new resource.
- date_
format str - Specifies date type.
yyyy-MM-dd
is used by default. Only data in CSV and JSON files has this attribute. Changing this parameter will create a new resource. - delimiter str
- Specifies data delimiter. Only data in CSV files has this attribute. Changing this parameter will create a new resource.
- description str
- Specifies description of the table. Changing this parameter will create a new resource.
- dli_
table_ strid - A resource ID in format of database_name/table_name. It is composed of the name of database which table belongs and the name of table, separated by a slash.
- escape_
char str - Specifies escape character. Backslashes (
\\
) are used by default. Only data in CSV files has this attribute. Changing this parameter will create a new resource. - name str
- Specifies the table name. The name can contain only digits, letters, and underscores, but cannot contain only digits or start with an underscore. Length range: 1 to 128 characters. Changing this parameter will create a new resource.
- quote_
char str - Specifies reference character. Double quotation marks (
\
) are used by default. Only data in CSV files has this attribute. Changing this parameter will create a new resource. - region str
- Specifies the region in which to create the dli table resource. If omitted, the provider-level region will be used. Changing this parameter will create a new resource.
- timeouts
Dli
Table Timeouts Args - timestamp_
format str - Specifies timestamp type.
yyyy-MM-dd HH:mm:ss
is used by default. Only data in CSV and JSON files has this attribute. Changing this parameter will create a new resource. - with_
column_ boolheader - Specifies whether the table header is included in the data file. Only data in CSV files has this attribute. Changing this parameter will create a new resource.
- data
Location String - Specifies data storage location. Changing this parameter will create
a newresource. The options are as follows:
- OBS: Data stored in OBS tables is applicable to delay-insensitive services, such as historical data statistics and analysis.
- database
Name String - Specifies the database name which the table belongs to. Changing this parameter will create a new resource.
- bucket
Location String Specifies storage path of data which will be import to the OBS table. Changing this parameter will create a new resource.
If you need to import data stored in OBS to the OBS table, set this parameter to the path of a folder. If the table creation path is a file, data fails to be imported. which must be a path on OBS and must begin with obs.
- columns List<Property Map>
- Specifies Columns of the new table. Structure is documented below. Changing this parameter will create a new resource.
- data
Format String - Specifies type of the data to be added to the OBS table. The options: parquet, orc, csv, json, carbon, and avro. Changing this parameter will create a new resource.
- date
Format String - Specifies date type.
yyyy-MM-dd
is used by default. Only data in CSV and JSON files has this attribute. Changing this parameter will create a new resource. - delimiter String
- Specifies data delimiter. Only data in CSV files has this attribute. Changing this parameter will create a new resource.
- description String
- Specifies description of the table. Changing this parameter will create a new resource.
- dli
Table StringId - A resource ID in format of database_name/table_name. It is composed of the name of database which table belongs and the name of table, separated by a slash.
- escape
Char String - Specifies escape character. Backslashes (
\\
) are used by default. Only data in CSV files has this attribute. Changing this parameter will create a new resource. - name String
- Specifies the table name. The name can contain only digits, letters, and underscores, but cannot contain only digits or start with an underscore. Length range: 1 to 128 characters. Changing this parameter will create a new resource.
- quote
Char String - Specifies reference character. Double quotation marks (
\
) are used by default. Only data in CSV files has this attribute. Changing this parameter will create a new resource. - region String
- Specifies the region in which to create the dli table resource. If omitted, the provider-level region will be used. Changing this parameter will create a new resource.
- timeouts Property Map
- timestamp
Format String - Specifies timestamp type.
yyyy-MM-dd HH:mm:ss
is used by default. Only data in CSV and JSON files has this attribute. Changing this parameter will create a new resource. - with
Column BooleanHeader - Specifies whether the table header is included in the data file. Only data in CSV files has this attribute. Changing this parameter will create a new resource.
Outputs
All input properties are implicitly available as output properties. Additionally, the DliTable resource produces the following output properties:
- Id string
- The provider-assigned unique ID for this managed resource.
- Id string
- The provider-assigned unique ID for this managed resource.
- id String
- The provider-assigned unique ID for this managed resource.
- id string
- The provider-assigned unique ID for this managed resource.
- id str
- The provider-assigned unique ID for this managed resource.
- id String
- The provider-assigned unique ID for this managed resource.
Look up Existing DliTable Resource
Get an existing DliTable resource’s state with the given name, ID, and optional extra properties used to qualify the lookup.
public static get(name: string, id: Input<ID>, state?: DliTableState, opts?: CustomResourceOptions): DliTable
@staticmethod
def get(resource_name: str,
id: str,
opts: Optional[ResourceOptions] = None,
bucket_location: Optional[str] = None,
columns: Optional[Sequence[DliTableColumnArgs]] = None,
data_format: Optional[str] = None,
data_location: Optional[str] = None,
database_name: Optional[str] = None,
date_format: Optional[str] = None,
delimiter: Optional[str] = None,
description: Optional[str] = None,
dli_table_id: Optional[str] = None,
escape_char: Optional[str] = None,
name: Optional[str] = None,
quote_char: Optional[str] = None,
region: Optional[str] = None,
timeouts: Optional[DliTableTimeoutsArgs] = None,
timestamp_format: Optional[str] = None,
with_column_header: Optional[bool] = None) -> DliTable
func GetDliTable(ctx *Context, name string, id IDInput, state *DliTableState, opts ...ResourceOption) (*DliTable, error)
public static DliTable Get(string name, Input<string> id, DliTableState? state, CustomResourceOptions? opts = null)
public static DliTable get(String name, Output<String> id, DliTableState state, CustomResourceOptions options)
resources: _: type: flexibleengine:DliTable get: id: ${id}
- name
- The unique name of the resulting resource.
- id
- The unique provider ID of the resource to lookup.
- state
- Any extra arguments used during the lookup.
- opts
- A bag of options that control this resource's behavior.
- resource_name
- The unique name of the resulting resource.
- id
- The unique provider ID of the resource to lookup.
- name
- The unique name of the resulting resource.
- id
- The unique provider ID of the resource to lookup.
- state
- Any extra arguments used during the lookup.
- opts
- A bag of options that control this resource's behavior.
- name
- The unique name of the resulting resource.
- id
- The unique provider ID of the resource to lookup.
- state
- Any extra arguments used during the lookup.
- opts
- A bag of options that control this resource's behavior.
- name
- The unique name of the resulting resource.
- id
- The unique provider ID of the resource to lookup.
- state
- Any extra arguments used during the lookup.
- opts
- A bag of options that control this resource's behavior.
- Bucket
Location string Specifies storage path of data which will be import to the OBS table. Changing this parameter will create a new resource.
If you need to import data stored in OBS to the OBS table, set this parameter to the path of a folder. If the table creation path is a file, data fails to be imported. which must be a path on OBS and must begin with obs.
- Columns
List<Dli
Table Column> - Specifies Columns of the new table. Structure is documented below. Changing this parameter will create a new resource.
- Data
Format string - Specifies type of the data to be added to the OBS table. The options: parquet, orc, csv, json, carbon, and avro. Changing this parameter will create a new resource.
- Data
Location string - Specifies data storage location. Changing this parameter will create
a newresource. The options are as follows:
- OBS: Data stored in OBS tables is applicable to delay-insensitive services, such as historical data statistics and analysis.
- Database
Name string - Specifies the database name which the table belongs to. Changing this parameter will create a new resource.
- Date
Format string - Specifies date type.
yyyy-MM-dd
is used by default. Only data in CSV and JSON files has this attribute. Changing this parameter will create a new resource. - Delimiter string
- Specifies data delimiter. Only data in CSV files has this attribute. Changing this parameter will create a new resource.
- Description string
- Specifies description of the table. Changing this parameter will create a new resource.
- Dli
Table stringId - A resource ID in format of database_name/table_name. It is composed of the name of database which table belongs and the name of table, separated by a slash.
- Escape
Char string - Specifies escape character. Backslashes (
\\
) are used by default. Only data in CSV files has this attribute. Changing this parameter will create a new resource. - Name string
- Specifies the table name. The name can contain only digits, letters, and underscores, but cannot contain only digits or start with an underscore. Length range: 1 to 128 characters. Changing this parameter will create a new resource.
- Quote
Char string - Specifies reference character. Double quotation marks (
\
) are used by default. Only data in CSV files has this attribute. Changing this parameter will create a new resource. - Region string
- Specifies the region in which to create the dli table resource. If omitted, the provider-level region will be used. Changing this parameter will create a new resource.
- Timeouts
Dli
Table Timeouts - Timestamp
Format string - Specifies timestamp type.
yyyy-MM-dd HH:mm:ss
is used by default. Only data in CSV and JSON files has this attribute. Changing this parameter will create a new resource. - With
Column boolHeader - Specifies whether the table header is included in the data file. Only data in CSV files has this attribute. Changing this parameter will create a new resource.
- Bucket
Location string Specifies storage path of data which will be import to the OBS table. Changing this parameter will create a new resource.
If you need to import data stored in OBS to the OBS table, set this parameter to the path of a folder. If the table creation path is a file, data fails to be imported. which must be a path on OBS and must begin with obs.
- Columns
[]Dli
Table Column Args - Specifies Columns of the new table. Structure is documented below. Changing this parameter will create a new resource.
- Data
Format string - Specifies type of the data to be added to the OBS table. The options: parquet, orc, csv, json, carbon, and avro. Changing this parameter will create a new resource.
- Data
Location string - Specifies data storage location. Changing this parameter will create
a newresource. The options are as follows:
- OBS: Data stored in OBS tables is applicable to delay-insensitive services, such as historical data statistics and analysis.
- Database
Name string - Specifies the database name which the table belongs to. Changing this parameter will create a new resource.
- Date
Format string - Specifies date type.
yyyy-MM-dd
is used by default. Only data in CSV and JSON files has this attribute. Changing this parameter will create a new resource. - Delimiter string
- Specifies data delimiter. Only data in CSV files has this attribute. Changing this parameter will create a new resource.
- Description string
- Specifies description of the table. Changing this parameter will create a new resource.
- Dli
Table stringId - A resource ID in format of database_name/table_name. It is composed of the name of database which table belongs and the name of table, separated by a slash.
- Escape
Char string - Specifies escape character. Backslashes (
\\
) are used by default. Only data in CSV files has this attribute. Changing this parameter will create a new resource. - Name string
- Specifies the table name. The name can contain only digits, letters, and underscores, but cannot contain only digits or start with an underscore. Length range: 1 to 128 characters. Changing this parameter will create a new resource.
- Quote
Char string - Specifies reference character. Double quotation marks (
\
) are used by default. Only data in CSV files has this attribute. Changing this parameter will create a new resource. - Region string
- Specifies the region in which to create the dli table resource. If omitted, the provider-level region will be used. Changing this parameter will create a new resource.
- Timeouts
Dli
Table Timeouts Args - Timestamp
Format string - Specifies timestamp type.
yyyy-MM-dd HH:mm:ss
is used by default. Only data in CSV and JSON files has this attribute. Changing this parameter will create a new resource. - With
Column boolHeader - Specifies whether the table header is included in the data file. Only data in CSV files has this attribute. Changing this parameter will create a new resource.
- bucket
Location String Specifies storage path of data which will be import to the OBS table. Changing this parameter will create a new resource.
If you need to import data stored in OBS to the OBS table, set this parameter to the path of a folder. If the table creation path is a file, data fails to be imported. which must be a path on OBS and must begin with obs.
- columns
List<Dli
Table Column> - Specifies Columns of the new table. Structure is documented below. Changing this parameter will create a new resource.
- data
Format String - Specifies type of the data to be added to the OBS table. The options: parquet, orc, csv, json, carbon, and avro. Changing this parameter will create a new resource.
- data
Location String - Specifies data storage location. Changing this parameter will create
a newresource. The options are as follows:
- OBS: Data stored in OBS tables is applicable to delay-insensitive services, such as historical data statistics and analysis.
- database
Name String - Specifies the database name which the table belongs to. Changing this parameter will create a new resource.
- date
Format String - Specifies date type.
yyyy-MM-dd
is used by default. Only data in CSV and JSON files has this attribute. Changing this parameter will create a new resource. - delimiter String
- Specifies data delimiter. Only data in CSV files has this attribute. Changing this parameter will create a new resource.
- description String
- Specifies description of the table. Changing this parameter will create a new resource.
- dli
Table StringId - A resource ID in format of database_name/table_name. It is composed of the name of database which table belongs and the name of table, separated by a slash.
- escape
Char String - Specifies escape character. Backslashes (
\\
) are used by default. Only data in CSV files has this attribute. Changing this parameter will create a new resource. - name String
- Specifies the table name. The name can contain only digits, letters, and underscores, but cannot contain only digits or start with an underscore. Length range: 1 to 128 characters. Changing this parameter will create a new resource.
- quote
Char String - Specifies reference character. Double quotation marks (
\
) are used by default. Only data in CSV files has this attribute. Changing this parameter will create a new resource. - region String
- Specifies the region in which to create the dli table resource. If omitted, the provider-level region will be used. Changing this parameter will create a new resource.
- timeouts
Dli
Table Timeouts - timestamp
Format String - Specifies timestamp type.
yyyy-MM-dd HH:mm:ss
is used by default. Only data in CSV and JSON files has this attribute. Changing this parameter will create a new resource. - with
Column BooleanHeader - Specifies whether the table header is included in the data file. Only data in CSV files has this attribute. Changing this parameter will create a new resource.
- bucket
Location string Specifies storage path of data which will be import to the OBS table. Changing this parameter will create a new resource.
If you need to import data stored in OBS to the OBS table, set this parameter to the path of a folder. If the table creation path is a file, data fails to be imported. which must be a path on OBS and must begin with obs.
- columns
Dli
Table Column[] - Specifies Columns of the new table. Structure is documented below. Changing this parameter will create a new resource.
- data
Format string - Specifies type of the data to be added to the OBS table. The options: parquet, orc, csv, json, carbon, and avro. Changing this parameter will create a new resource.
- data
Location string - Specifies data storage location. Changing this parameter will create
a newresource. The options are as follows:
- OBS: Data stored in OBS tables is applicable to delay-insensitive services, such as historical data statistics and analysis.
- database
Name string - Specifies the database name which the table belongs to. Changing this parameter will create a new resource.
- date
Format string - Specifies date type.
yyyy-MM-dd
is used by default. Only data in CSV and JSON files has this attribute. Changing this parameter will create a new resource. - delimiter string
- Specifies data delimiter. Only data in CSV files has this attribute. Changing this parameter will create a new resource.
- description string
- Specifies description of the table. Changing this parameter will create a new resource.
- dli
Table stringId - A resource ID in format of database_name/table_name. It is composed of the name of database which table belongs and the name of table, separated by a slash.
- escape
Char string - Specifies escape character. Backslashes (
\\
) are used by default. Only data in CSV files has this attribute. Changing this parameter will create a new resource. - name string
- Specifies the table name. The name can contain only digits, letters, and underscores, but cannot contain only digits or start with an underscore. Length range: 1 to 128 characters. Changing this parameter will create a new resource.
- quote
Char string - Specifies reference character. Double quotation marks (
\
) are used by default. Only data in CSV files has this attribute. Changing this parameter will create a new resource. - region string
- Specifies the region in which to create the dli table resource. If omitted, the provider-level region will be used. Changing this parameter will create a new resource.
- timeouts
Dli
Table Timeouts - timestamp
Format string - Specifies timestamp type.
yyyy-MM-dd HH:mm:ss
is used by default. Only data in CSV and JSON files has this attribute. Changing this parameter will create a new resource. - with
Column booleanHeader - Specifies whether the table header is included in the data file. Only data in CSV files has this attribute. Changing this parameter will create a new resource.
- bucket_
location str Specifies storage path of data which will be import to the OBS table. Changing this parameter will create a new resource.
If you need to import data stored in OBS to the OBS table, set this parameter to the path of a folder. If the table creation path is a file, data fails to be imported. which must be a path on OBS and must begin with obs.
- columns
Sequence[Dli
Table Column Args] - Specifies Columns of the new table. Structure is documented below. Changing this parameter will create a new resource.
- data_
format str - Specifies type of the data to be added to the OBS table. The options: parquet, orc, csv, json, carbon, and avro. Changing this parameter will create a new resource.
- data_
location str - Specifies data storage location. Changing this parameter will create
a newresource. The options are as follows:
- OBS: Data stored in OBS tables is applicable to delay-insensitive services, such as historical data statistics and analysis.
- database_
name str - Specifies the database name which the table belongs to. Changing this parameter will create a new resource.
- date_
format str - Specifies date type.
yyyy-MM-dd
is used by default. Only data in CSV and JSON files has this attribute. Changing this parameter will create a new resource. - delimiter str
- Specifies data delimiter. Only data in CSV files has this attribute. Changing this parameter will create a new resource.
- description str
- Specifies description of the table. Changing this parameter will create a new resource.
- dli_
table_ strid - A resource ID in format of database_name/table_name. It is composed of the name of database which table belongs and the name of table, separated by a slash.
- escape_
char str - Specifies escape character. Backslashes (
\\
) are used by default. Only data in CSV files has this attribute. Changing this parameter will create a new resource. - name str
- Specifies the table name. The name can contain only digits, letters, and underscores, but cannot contain only digits or start with an underscore. Length range: 1 to 128 characters. Changing this parameter will create a new resource.
- quote_
char str - Specifies reference character. Double quotation marks (
\
) are used by default. Only data in CSV files has this attribute. Changing this parameter will create a new resource. - region str
- Specifies the region in which to create the dli table resource. If omitted, the provider-level region will be used. Changing this parameter will create a new resource.
- timeouts
Dli
Table Timeouts Args - timestamp_
format str - Specifies timestamp type.
yyyy-MM-dd HH:mm:ss
is used by default. Only data in CSV and JSON files has this attribute. Changing this parameter will create a new resource. - with_
column_ boolheader - Specifies whether the table header is included in the data file. Only data in CSV files has this attribute. Changing this parameter will create a new resource.
- bucket
Location String Specifies storage path of data which will be import to the OBS table. Changing this parameter will create a new resource.
If you need to import data stored in OBS to the OBS table, set this parameter to the path of a folder. If the table creation path is a file, data fails to be imported. which must be a path on OBS and must begin with obs.
- columns List<Property Map>
- Specifies Columns of the new table. Structure is documented below. Changing this parameter will create a new resource.
- data
Format String - Specifies type of the data to be added to the OBS table. The options: parquet, orc, csv, json, carbon, and avro. Changing this parameter will create a new resource.
- data
Location String - Specifies data storage location. Changing this parameter will create
a newresource. The options are as follows:
- OBS: Data stored in OBS tables is applicable to delay-insensitive services, such as historical data statistics and analysis.
- database
Name String - Specifies the database name which the table belongs to. Changing this parameter will create a new resource.
- date
Format String - Specifies date type.
yyyy-MM-dd
is used by default. Only data in CSV and JSON files has this attribute. Changing this parameter will create a new resource. - delimiter String
- Specifies data delimiter. Only data in CSV files has this attribute. Changing this parameter will create a new resource.
- description String
- Specifies description of the table. Changing this parameter will create a new resource.
- dli
Table StringId - A resource ID in format of database_name/table_name. It is composed of the name of database which table belongs and the name of table, separated by a slash.
- escape
Char String - Specifies escape character. Backslashes (
\\
) are used by default. Only data in CSV files has this attribute. Changing this parameter will create a new resource. - name String
- Specifies the table name. The name can contain only digits, letters, and underscores, but cannot contain only digits or start with an underscore. Length range: 1 to 128 characters. Changing this parameter will create a new resource.
- quote
Char String - Specifies reference character. Double quotation marks (
\
) are used by default. Only data in CSV files has this attribute. Changing this parameter will create a new resource. - region String
- Specifies the region in which to create the dli table resource. If omitted, the provider-level region will be used. Changing this parameter will create a new resource.
- timeouts Property Map
- timestamp
Format String - Specifies timestamp type.
yyyy-MM-dd HH:mm:ss
is used by default. Only data in CSV and JSON files has this attribute. Changing this parameter will create a new resource. - with
Column BooleanHeader - Specifies whether the table header is included in the data file. Only data in CSV files has this attribute. Changing this parameter will create a new resource.
Supporting Types
DliTableColumn, DliTableColumnArgs
- Name string
- Specifies the table name. The name can contain only digits, letters, and underscores, but cannot contain only digits or start with an underscore. Length range: 1 to 128 characters. Changing this parameter will create a new resource.
- Type string
- Specifies data type of column. Changing this parameter will create a new resource.
- Description string
- Specifies description of the table. Changing this parameter will create a new resource.
- Is
Partition bool Specifies whether the column is a partition column. The value
true
indicates a partition column, and the value false indicates a non-partition column. The default value is false. Changing this parameter will create a new resource.When creating a partition table, ensure that at least one column in the table is a non-partition column.
- Name string
- Specifies the table name. The name can contain only digits, letters, and underscores, but cannot contain only digits or start with an underscore. Length range: 1 to 128 characters. Changing this parameter will create a new resource.
- Type string
- Specifies data type of column. Changing this parameter will create a new resource.
- Description string
- Specifies description of the table. Changing this parameter will create a new resource.
- Is
Partition bool Specifies whether the column is a partition column. The value
true
indicates a partition column, and the value false indicates a non-partition column. The default value is false. Changing this parameter will create a new resource.When creating a partition table, ensure that at least one column in the table is a non-partition column.
- name String
- Specifies the table name. The name can contain only digits, letters, and underscores, but cannot contain only digits or start with an underscore. Length range: 1 to 128 characters. Changing this parameter will create a new resource.
- type String
- Specifies data type of column. Changing this parameter will create a new resource.
- description String
- Specifies description of the table. Changing this parameter will create a new resource.
- is
Partition Boolean Specifies whether the column is a partition column. The value
true
indicates a partition column, and the value false indicates a non-partition column. The default value is false. Changing this parameter will create a new resource.When creating a partition table, ensure that at least one column in the table is a non-partition column.
- name string
- Specifies the table name. The name can contain only digits, letters, and underscores, but cannot contain only digits or start with an underscore. Length range: 1 to 128 characters. Changing this parameter will create a new resource.
- type string
- Specifies data type of column. Changing this parameter will create a new resource.
- description string
- Specifies description of the table. Changing this parameter will create a new resource.
- is
Partition boolean Specifies whether the column is a partition column. The value
true
indicates a partition column, and the value false indicates a non-partition column. The default value is false. Changing this parameter will create a new resource.When creating a partition table, ensure that at least one column in the table is a non-partition column.
- name str
- Specifies the table name. The name can contain only digits, letters, and underscores, but cannot contain only digits or start with an underscore. Length range: 1 to 128 characters. Changing this parameter will create a new resource.
- type str
- Specifies data type of column. Changing this parameter will create a new resource.
- description str
- Specifies description of the table. Changing this parameter will create a new resource.
- is_
partition bool Specifies whether the column is a partition column. The value
true
indicates a partition column, and the value false indicates a non-partition column. The default value is false. Changing this parameter will create a new resource.When creating a partition table, ensure that at least one column in the table is a non-partition column.
- name String
- Specifies the table name. The name can contain only digits, letters, and underscores, but cannot contain only digits or start with an underscore. Length range: 1 to 128 characters. Changing this parameter will create a new resource.
- type String
- Specifies data type of column. Changing this parameter will create a new resource.
- description String
- Specifies description of the table. Changing this parameter will create a new resource.
- is
Partition Boolean Specifies whether the column is a partition column. The value
true
indicates a partition column, and the value false indicates a non-partition column. The default value is false. Changing this parameter will create a new resource.When creating a partition table, ensure that at least one column in the table is a non-partition column.
DliTableTimeouts, DliTableTimeoutsArgs
- Delete string
- Delete string
- delete String
- delete string
- delete str
- delete String
Import
DLI table can be imported by id
. It is composed of the name of database which table belongs and the name of table,
separated by a slash. For example,
$ pulumi import flexibleengine:index/dliTable:DliTable example <database_name>/<table_name>
To learn more about importing existing cloud resources, see Importing resources.
Package Details
- Repository
- flexibleengine flexibleenginecloud/terraform-provider-flexibleengine
- License
- Notes
- This Pulumi package is based on the
flexibleengine
Terraform Provider.