Author | Sander Stad (@sqlstad, sqlstad.nl) |
Availability | Windows, Linux, macOS |
Want to see the source code for this command? Check out Get-DbaRandomizedDatasetTemplate on GitHub.
Want to see the Bill Of Health for this command? Check out Get-DbaRandomizedDatasetTemplate.
Retrieves JSON template files that define column structures for generating realistic test data
Retrieves JSON template files from default and custom directories that define how to generate realistic test datasets. These templates specify column names, data types, and semantic subtypes (like Name.FirstName, Address.City) for creating structured sample data for development and testing environments. The default templates include PersonalData with common fields like names, addresses, and birthdates, and you can specify custom template directories to include organization-specific data patterns.
Get-DbaRandomizedDatasetTemplate
[[-Template] <String[]>]
[[-Path] <String[]>]
[-ExcludeDefault]
[-EnableException]
[<CommonParameters>]
PS > Get-DbaRandomizedDatasetTemplate
Get the templates from the default directory
PS > Get-DbaRandomizedDatasetTemplate -Template Personaldata, Test
Get the templates from thedefault directory and filter on PersonalData and Test
PS > Get-DbaRandomizedDatasetTemplate -Path C:\DatasetTemplates
Get the templates from a custom directory
Specifies which template files to retrieve by name (without the .json extension).
Use this to filter results when you only need specific templates like "PersonalData" or custom templates.
If not specified, all available templates from the specified paths are returned.
Alias | |
Required | False |
Pipeline | false |
Default Value |
Specifies one or more directory paths containing custom JSON template files for data generation.
Use this when your organization has created custom templates beyond the default dbatools templates.
Templates from these paths are added to the default templates unless -ExcludeDefault is specified.
Alias | |
Required | False |
Pipeline | false |
Default Value |
Excludes the built-in dbatools templates from the results.
Use this when you only want to work with custom templates from specified paths.
The default templates include common data patterns like PersonalData with names, addresses, and dates.
Alias | |
Required | False |
Pipeline | false |
Default Value | False |
By default, when something goes wrong we try to catch it, interpret it and give you a friendly warning message.
This avoids overwhelming you with "sea of red" exceptions, but is inconvenient because it basically disables advanced scripting.
Using this switch turns this "nice by default" feature off and enables you to catch exceptions with your own try/catch.
Alias | |
Required | False |
Pipeline | false |
Default Value | False |