Skip to content

Instantly share code, notes, and snippets.

View rossbelmont's full-sized avatar

Ross Belmont rossbelmont

View GitHub Profile
@rossbelmont
rossbelmont / retrieveMDforAuthProviders.xml
Last active February 22, 2022 21:09
Metadata retrieve for AuthProviders
<?xml version="1.0" encoding="UTF-8"?>
<Package xmlns="http://soap.sforce.com/2006/04/metadata">
<types>
<members>*</members>
<name>AuthProvider</name>
</types>
<version>50.0</version>
</Package>
@rossbelmont
rossbelmont / CategoryQualifier.json
Last active April 20, 2022 02:09
Northwind eCommerce data model in DynamoDB and Salesforce
{
"columns": {
"pk": {
"filter": "categories#%",
"values": [
{
"definition": "\"categories#\" + TEXT(category)"
}
]
},
{
"tableLocation": {
"catalog": "AwsDataCatalog",
"database": "works_of_art"
},
"tableName": "artwork",
"extendedQualifiers": {
"workgroup": "primary"
},
"keyColumns": [
@rossbelmont
rossbelmont / WorksOfArt.json
Last active April 18, 2022 14:58
Qualifier for Athena-backed External Object
{
"tableLocation": {
"catalog": "AwsDataCatalog",
"database": "mydb"
},
"tableName": "works_of_art",
"extendedQualifiers": {
"workgroup": "primary"
},
"keyColumns": [
@rossbelmont
rossbelmont / EmployeeQualifier.json
Last active April 20, 2022 16:12
Formulas in Qualifiers • Simple Example
{
"columns": {
"fullName": {
"virtual": "true",
"values": [{
"definition": "FirstName+\" \"+LastName"
}]
}
}
}
@rossbelmont
rossbelmont / package.xml
Last active May 9, 2022 23:55
Private Connect demo assets
<?xml version="1.0" encoding="UTF-8"?>
<Package xmlns="http://soap.sforce.com/2006/04/metadata">
<types>
<members>Assign_Rating</members>
<name>QuickAction</name>
</types>
<types>
<members>privateConnectDemo2022022402</members>
<name>OutboundNetworkConnection</name>
</types>
@rossbelmont
rossbelmont / README.md
Last active September 14, 2022 02:17
Minimal IAM Permissions to support the Salesforce Connect adapter for Amazon Athena

Minimal IAM Permissions • Salesforce Connect adapter for Amazon Athena

The following represents a configuration of minimal IAM permissions needed to support the Salesforce Connect adapter for Amazon Athena. Specifically, this example uses a separate (dedicated) workgroup for Salesforce Connect to use with Athena, as well as specific S3 buckets containing the relevant source data.

This limits access to business data while providing enough access to metadata to make configuration easier for administrators. Note the following items in ALL_CAPS that will need to be replaced in your configuration:

  • ACCOUNT_ID: ID of the AWS Account containing all the above resources (e.g. 467032906895)
  • AWS_REGION: Geographical region containing the S3 bucket used by the workgroup (e.g. us-east-1)
  • BUCKET_1_NAME: name of the S3 bucket used to house the source data
  • BUCKET_N_NAME: included for instructional purposes in case Athena reads from multiple buckets
  • RESULTS_BUCKET_NAME: name of the S3 bucket used by
@rossbelmont
rossbelmont / README.md
Last active November 3, 2022 12:18
MD API PermSet Issue

Potential bug in the Metadata API

Here's a note from one of our customer-facing architects:

I'm trying to load external credentials as metadata. Apparently, I can not push metadata that has a perm set and header all at once. I have to delete the perm set from the metadata for it to work. If I then resubmit the original metadata, it’s successful.

I have to do it twice, which is a bummer — deployment fails and I have to manually intervene.

@rossbelmont
rossbelmont / .gitignore
Last active February 14, 2023 23:03
eCommerce Order Example - GraphQL
.DS_Store