Skip to content

Instantly share code, notes, and snippets.

@nicmart

nicmart/mergeintotest.sql

Last active September 20, 2024 13:43
Show Gist options
  • Save nicmart/3d2407add34664f5561486b83fea9668 to your computer and use it in GitHub Desktop.
Save nicmart/3d2407add34664f5561486b83fea9668 to your computer and use it in GitHub Desktop.
Download ZIP
Raw
mergeintotest.sql
SET SESSION RUNTIMECAP '300 minutes';
CREATE TABLE IF NOT EXISTS "gametransaction" (
"amountReal_eur" FLOAT,
"gameTransactionId" VARCHAR(255),
"jackpotAmount_base" FLOAT,
"walletAmount" FLOAT,
"betslipId" VARCHAR(255),
"reason" VARCHAR(255),
"jackpotContribution_base" FLOAT,
"providerSportsbookId" VARCHAR(255),
"balanceAfter_eur" FLOAT,
"fxSpread" FLOAT,
"jackpotAmount" FLOAT,
"sportsbook" VARCHAR(255),
"providerAmount" FLOAT,
"amount_eur" FLOAT,
"availableBalanceAfter_base" FLOAT,
"availableBalanceAfterBonus_eur" FLOAT,
"availableBalanceAfterReal_base" FLOAT,
"availableBalanceAfterBonus_base" FLOAT,
"balanceAfterBonus_base" FLOAT,
"amountBonus" FLOAT,
"details" VARCHAR(255),
"providerGameTransactionId" VARCHAR(255),
"walletAmount_eur" FLOAT,
"discardable" BOOLEAN,
"_CELONIS_INPUT_FILE" VARCHAR(255),
"jackpotContribution" FLOAT,
"terminalRef" VARCHAR(255),
"shopRef" VARCHAR(255),
"sportsbookWinnings_base" FLOAT,
"fxRate" FLOAT,
"availableBalanceAfter_eur" FLOAT,
"balanceAfter_base" FLOAT,
"sessionId" VARCHAR(255),
"status" VARCHAR(255),
"sportsbookWinnings_eur" FLOAT,
"betslipSettledAt" TIMESTAMP,
"sportsbookStatus" VARCHAR(255),
"balanceAfter" FLOAT,
"transactionReason" VARCHAR(255),
"betslip" VARCHAR(255),
"taxAmount" FLOAT,
"device" VARCHAR(255),
"succeededAt" TIMESTAMP,
"promotionId" VARCHAR(255),
"sportsbookId" VARCHAR(255),
"taxAmount_eur" FLOAT,
"taxAmount_base" FLOAT,
"availableBalanceAfterBonus" FLOAT,
"version" INTEGER,
"promotional" BOOLEAN,
"balanceAfterBonus" FLOAT,
"gameTransactionType" VARCHAR(255),
"providerGameSessionId" VARCHAR(255),
"currencyCode" VARCHAR(255),
"amount" FLOAT,
"userId" VARCHAR(255),
"providerAmount_eur" FLOAT,
"jackpotContribution_eur" FLOAT,
"errorCode" VARCHAR(255),
"message" VARCHAR(255),
"walletAmount_base" FLOAT,
"processedAt" TIMESTAMP,
"provider" VARCHAR(255),
"syndicateSessionId" VARCHAR(255),
"betslipWinnings_eur" FLOAT,
"availableBalanceAfterReal" FLOAT,
"gameRoundId" VARCHAR(255),
"betslipStatus" VARCHAR(255),
"balanceAfterReal" FLOAT,
"studio" VARCHAR(255),
"availableBalanceAfterReal_eur" FLOAT,
"amountReal_base" FLOAT,
"betslipWinnings_base" FLOAT,
"updatedAt" TIMESTAMP,
"gameSessionId" VARCHAR(255),
"amountBonus_base" FLOAT,
"code" VARCHAR(255),
"providerAmount_base" FLOAT,
"providerRoundId" VARCHAR(255),
"providerBetslipId" VARCHAR(255),
"amount_base" FLOAT,
"balanceAfterReal_base" FLOAT,
"availableBalanceAfter" FLOAT,
"gameRoundIndex" INTEGER,
"balanceAfterReal_eur" FLOAT,
"jackpotAmount_eur" FLOAT,
"amountReal" FLOAT,
"betslipWinnings" FLOAT,
"sportsbookWinnings" FLOAT,
"createdAt" TIMESTAMP,
"amounts" VARCHAR(255),
"gameId" VARCHAR(255),
"balanceAfterBonus_eur" FLOAT,
"amountBonus_eur" FLOAT,
"walletCurrencyCode" VARCHAR(255),
"_CELONIS_CHANGE_DATE" timestamptz(3)
);
CREATE PROJECTION IF NOT EXISTS "gametransaction_PK" AS SELECT "gameTransactionId" FROM "gametransaction";
-- insert 1M rows into target table -- decrease the joins and the limit to adjust the number of rows
INSERT INTO "gametransaction"
SELECT
RANDOM() * 1000 AS amountReal_eur,
LPAD(CONCAT('transaction_', CAST(ABS(RANDOM() % 10000) AS VARCHAR)), 81, '0') AS gameTransactionId,
RANDOM() * 1000 AS jackpotAmount_base,
RANDOM() * 1000 AS walletAmount,
LPAD(CONCAT('betslip_', CAST(ABS(RANDOM() % 10000) AS VARCHAR)), 81, '0') AS betslipId,
LPAD(CONCAT('reason_', CAST(ABS(RANDOM() % 10000) AS VARCHAR)), 81, '0') AS reason,
RANDOM() * 1000 AS jackpotContribution_base,
LPAD(CONCAT('providerSportsbook_', CAST(ABS(RANDOM() % 10000) AS VARCHAR)), 81, '0') AS providerSportsbookId,
RANDOM() * 1000 AS balanceAfter_eur,
RANDOM() * 100 AS fxSpread,
RANDOM() * 1000 AS jackpotAmount,
LPAD(CONCAT('sportsbook_', CAST(ABS(RANDOM() % 10000) AS VARCHAR)), 81, '0') AS sportsbook,
RANDOM() * 1000 AS providerAmount,
RANDOM() * 1000 AS amount_eur,
RANDOM() * 1000 AS availableBalanceAfter_base,
RANDOM() * 1000 AS availableBalanceAfterBonus_eur,
RANDOM() * 1000 AS availableBalanceAfterReal_base,
RANDOM() * 1000 AS availableBalanceAfterBonus_base,
RANDOM() * 1000 AS balanceAfterBonus_base,
RANDOM() * 1000 AS amountBonus,
LPAD(CONCAT('details_', CAST(ABS(RANDOM() % 10000) AS VARCHAR)), 81, '0') AS details,
LPAD(CONCAT('providerGameTransaction_', CAST(ABS(RANDOM() % 10000) AS VARCHAR)), 81, '0') AS providerGameTransactionId,
RANDOM() * 1000 AS walletAmount_eur,
RANDOM() < 0.5 AS discardable, -- Boolean
LPAD(CONCAT('file_', CAST(ABS(RANDOM() % 10000) AS VARCHAR)), 81, '0') AS _CELONIS_INPUT_FILE,
RANDOM() * 1000 AS jackpotContribution,
LPAD(CONCAT('terminal_', CAST(ABS(RANDOM() % 10000) AS VARCHAR)), 81, '0') AS terminalRef,
LPAD(CONCAT('shop_', CAST(ABS(RANDOM() % 10000) AS VARCHAR)), 81, '0') AS shopRef,
RANDOM() * 1000 AS sportsbookWinnings_base,
1 + RANDOM() * 0.1 AS fxRate,
RANDOM() * 1000 AS availableBalanceAfter_eur,
RANDOM() * 1000 AS balanceAfter_base,
LPAD(CONCAT('session_', CAST(ABS(RANDOM() % 10000) AS VARCHAR)), 81, '0') AS sessionId,
LPAD(CONCAT('status_', CAST(ABS(RANDOM() % 10000) AS VARCHAR)), 81, '0') AS status,
RANDOM() * 1000 AS sportsbookWinnings_eur,
TIMESTAMPADD('SECOND', RANDOMINT(100000000), '2022-01-01 00:00:00') AS betslipSettledAt,
LPAD(CONCAT('sportsbookStatus_', CAST(ABS(RANDOM() % 10000) AS VARCHAR)), 81, '0') AS sportsbookStatus,
RANDOM() * 1000 AS balanceAfter,
LPAD(CONCAT('reason_', CAST(ABS(RANDOM() % 10000) AS VARCHAR)), 81, '0') AS transactionReason,
LPAD(CONCAT('betslip_', CAST(ABS(RANDOM() % 10000) AS VARCHAR)), 81, '0') AS betslip,
RANDOM() * 100 AS taxAmount,
LPAD(CONCAT('device_', CAST(ABS(RANDOM() % 10000) AS VARCHAR)), 81, '0') AS device,
TIMESTAMPADD('SECOND', RANDOMINT(100000000), '2022-01-01 00:00:00') AS succeededAt,
LPAD(CONCAT('promotion_', CAST(ABS(RANDOM() % 10000) AS VARCHAR)), 81, '0') AS promotionId,
LPAD(CONCAT('sportsbook_', CAST(ABS(RANDOM() % 10000) AS VARCHAR)), 81, '0') AS sportsbookId,
RANDOM() * 100 AS taxAmount_eur,
RANDOM() * 100 AS taxAmount_base,
RANDOM() * 1000 AS availableBalanceAfterBonus,
ABS(RANDOM() % 10) AS version,
RANDOM() < 0.5 AS promotional, -- Boolean
RANDOM() * 1000 AS balanceAfterBonus,
LPAD(CONCAT('transactionType_', CAST(ABS(RANDOM() % 10000) AS VARCHAR)), 81, '0') AS gameTransactionType,
LPAD(CONCAT('gameSession_', CAST(ABS(RANDOM() % 10000) AS VARCHAR)), 81, '0') AS providerGameSessionId,
'USD' AS currencyCode, -- Randomize as needed
RANDOM() * 1000 AS amount,
LPAD(CONCAT('user_', CAST(ABS(RANDOM() % 10000) AS VARCHAR)), 81, '0') AS userId,
RANDOM() * 1000 AS providerAmount_eur,
RANDOM() * 100 AS jackpotContribution_eur,
LPAD(CONCAT('errorCode_', CAST(ABS(RANDOM() % 10000) AS VARCHAR)), 81, '0') AS errorCode,
LPAD(CONCAT('message_', CAST(ABS(RANDOM() % 10000) AS VARCHAR)), 81, '0') AS message,
RANDOM() * 1000 AS walletAmount_base,
TIMESTAMPADD('SECOND', RANDOMINT(100000000), '2022-01-01 00:00:00') AS processedAt,
LPAD(CONCAT('provider_', CAST(ABS(RANDOM() % 10000) AS VARCHAR)), 81, '0') AS provider,
LPAD(CONCAT('syndicate_', CAST(ABS(RANDOM() % 10000) AS VARCHAR)), 81, '0') AS syndicateSessionId,
RANDOM() * 1000 AS betslipWinnings_eur,
RANDOM() * 1000 AS availableBalanceAfterReal,
LPAD(CONCAT('gameRound_', CAST(ABS(RANDOM() % 10000) AS VARCHAR)), 81, '0') AS gameRoundId,
LPAD(CONCAT('status_', CAST(ABS(RANDOM() % 10000) AS VARCHAR)), 81, '0') AS betslipStatus,
RANDOM() * 1000 AS balanceAfterReal,
LPAD(CONCAT('studio_', CAST(ABS(RANDOM() % 10000) AS VARCHAR)), 81, '0') AS studio,
RANDOM() * 1000 AS availableBalanceAfterReal_eur,
RANDOM() * 1000 AS amountReal_base,
RANDOM() * 1000 AS betslipWinnings_base,
TIMESTAMPADD('SECOND', RANDOMINT(100000000), '2022-01-01 00:00:00') AS updatedAt,
LPAD(CONCAT('gameSession_', CAST(ABS(RANDOM() % 10000) AS VARCHAR)), 81, '0') AS gameSessionId,
RANDOM() * 1000 AS amountBonus_base,
LPAD(CONCAT('code_', CAST(ABS(RANDOM() % 10000) AS VARCHAR)), 81, '0') AS code,
RANDOM() * 1000 AS providerAmount_base,
LPAD(CONCAT('providerRound_', CAST(ABS(RANDOM() % 10000) AS VARCHAR)), 81, '0') AS providerRoundId,
LPAD(CONCAT('providerBetslip_', CAST(ABS(RANDOM() % 10000) AS VARCHAR)), 81, '0') AS providerBetslipId,
RANDOM() * 1000 AS amount_base,
RANDOM() * 1000 AS balanceAfterReal_base,
RANDOM() * 1000 AS availableBalanceAfter,
ABS(RANDOM() % 1000) AS gameRoundIndex,
RANDOM() * 1000 AS balanceAfterReal_eur,
RANDOM() * 1000 AS jackpotAmount_eur,
RANDOM() * 1000 AS amountReal,
RANDOM() * 1000 AS betslipWinnings,
RANDOM() * 1000 AS sportsbookWinnings,
TIMESTAMPADD('SECOND', RANDOMINT(100000000), '2022-01-01 00:00:00') AS createdAt,
LPAD(CONCAT('amounts_', CAST(ABS(RANDOM() % 10000) AS VARCHAR)), 81, '0') AS amounts,
LPAD(CONCAT('game_', CAST(ABS(RANDOM() % 10000) AS VARCHAR)), 81, '0') AS gameId,
RANDOM() * 1000 AS balanceAfterBonus_eur,
RANDOM() * 1000 AS amountBonus_eur,
'USD' AS wallet
FROM (SELECT 1 FROM (SELECT 1 UNION ALL SELECT 2 UNION ALL SELECT 3 UNION ALL SELECT 4) t1
CROSS JOIN (SELECT 1 UNION ALL SELECT 2 UNION ALL SELECT 3 UNION ALL SELECT 4) t2
CROSS JOIN (SELECT 1 UNION ALL SELECT 2 UNION ALL SELECT 3 UNION ALL SELECT 4) t3
CROSS JOIN (SELECT 1 UNION ALL SELECT 2 UNION ALL SELECT 3 UNION ALL SELECT 4) t4
CROSS JOIN (SELECT 1 UNION ALL SELECT 2 UNION ALL SELECT 3 UNION ALL SELECT 4) t5
CROSS JOIN (SELECT 1 UNION ALL SELECT 2 UNION ALL SELECT 3 UNION ALL SELECT 4) t6
CROSS JOIN (SELECT 1 UNION ALL SELECT 2 UNION ALL SELECT 3 UNION ALL SELECT 4) t7
CROSS JOIN (SELECT 1 UNION ALL SELECT 2 UNION ALL SELECT 3 UNION ALL SELECT 4) t8
CROSS JOIN (SELECT 1 UNION ALL SELECT 2 UNION ALL SELECT 3 UNION ALL SELECT 4) t9
CROSS JOIN (SELECT 1 UNION ALL SELECT 2 UNION ALL SELECT 3 UNION ALL SELECT 4) t10
) temp
LIMIT 1000000;
-- refresh projections
SELECT REFRESH('"public"."gametransaction"');
DROP TABLE IF EXISTS "_CELONIS_TMP_gametransaction" CASCADE;
CREATE LOCAL TEMPORARY TABLE IF NOT EXISTS "_CELONIS_TMP_gametransaction" (
"device" VARCHAR(81),
"promotionId" VARCHAR(81),
"providerAmount" FLOAT,
"availableBalanceAfterReal_base" FLOAT,
"sportsbookId" VARCHAR(81),
"amounts" VARCHAR(81),
"currencyCode" VARCHAR(81),
"jackpotContribution" FLOAT,
"promotional" BOOLEAN,
"amountReal_base" FLOAT,
"providerGameSessionId" VARCHAR(81),
"betslipWinnings_base" FLOAT,
"walletAmount_eur" FLOAT,
"betslipSettledAt" TIMESTAMP,
"jackpotAmount" FLOAT,
"provider" VARCHAR(81),
"balanceAfterBonus_base" FLOAT,
"amountReal" FLOAT,
"walletAmount_base" FLOAT,
"balanceAfterBonus_eur" FLOAT,
"balanceAfterReal_base" FLOAT,
"betslipWinnings" FLOAT,
"gameTransactionType" VARCHAR(81),
"walletAmount" FLOAT,
"balanceAfterReal" FLOAT,
"discardable" BOOLEAN,
"message" VARCHAR(81),
"amount" FLOAT,
"sportsbookWinnings_base" FLOAT,
"jackpotContribution_base" FLOAT,
"updatedAt" TIMESTAMP,
"availableBalanceAfterBonus_eur" FLOAT,
"taxAmount_eur" FLOAT,
"gameRoundId" VARCHAR(81),
"providerGameTransactionId" VARCHAR(81),
"balanceAfter_base" FLOAT,
"sportsbookWinnings_eur" FLOAT,
"availableBalanceAfterBonus" FLOAT,
"code" VARCHAR(81),
"amountReal_eur" FLOAT,
"availableBalanceAfter_eur" FLOAT,
"gameId" VARCHAR(81),
"syndicateSessionId" VARCHAR(81),
"gameSessionId" VARCHAR(81),
"amount_eur" FLOAT,
"providerRoundId" VARCHAR(81),
"errorCode" VARCHAR(81),
"availableBalanceAfterReal" FLOAT,
"betslipId" VARCHAR(81),
"fxSpread" FLOAT,
"balanceAfter_eur" FLOAT,
"processedAt" TIMESTAMP,
"providerBetslipId" VARCHAR(81),
"betslipStatus" VARCHAR(81),
"walletCurrencyCode" VARCHAR(81),
"fxRate" FLOAT,
"gameTransactionId" VARCHAR(81),
"providerAmount_base" FLOAT,
"sportsbookStatus" VARCHAR(81),
"balanceAfterReal_eur" FLOAT,
"reason" VARCHAR(81),
"jackpotContribution_eur" FLOAT,
"amountBonus" FLOAT,
"providerSportsbookId" VARCHAR(81),
"providerAmount_eur" FLOAT,
"balanceAfter" FLOAT,
"details" VARCHAR(81),
"createdAt" TIMESTAMP,
"sportsbook" VARCHAR(81),
"studio" VARCHAR(81),
"amountBonus_eur" FLOAT,
"availableBalanceAfterBonus_base" FLOAT,
"_CELONIS_INPUT_FILE" VARCHAR(81),
"version" INTEGER,
"taxAmount_base" FLOAT,
"jackpotAmount_base" FLOAT,
"shopRef" VARCHAR(81),
"taxAmount" FLOAT,
"jackpotAmount_eur" FLOAT,
"succeededAt" TIMESTAMP,
"sportsbookWinnings" FLOAT,
"gameRoundIndex" INTEGER,
"terminalRef" VARCHAR(81),
"amountBonus_base" FLOAT,
"userId" VARCHAR(81),
"balanceAfterBonus" FLOAT,
"betslip" VARCHAR(81),
"transactionReason" VARCHAR(81),
"availableBalanceAfter_base" FLOAT,
"betslipWinnings_eur" FLOAT,
"availableBalanceAfterReal_eur" FLOAT,
"availableBalanceAfter" FLOAT,
"status" VARCHAR(81),
"sessionId" VARCHAR(81),
"amount_base" FLOAT
) ON COMMIT PRESERVE ROWS;
-- insert 30k random rows into temporary table
INSERT INTO "_CELONIS_TMP_gametransaction"
SELECT
LPAD(CONCAT('device_', CAST(ABS(RANDOM() % 10000) AS VARCHAR)), 81, '0') AS device,
LPAD(CONCAT('promotion_', CAST(ABS(RANDOM() % 10000) AS VARCHAR)), 81, '0') AS promotionId,
RANDOM() * 1000 AS providerAmount,
RANDOM() * 1000 AS availableBalanceAfterReal_base,
LPAD(CONCAT('sportsbook_', CAST(ABS(RANDOM() % 10000) AS VARCHAR)), 81, '0') AS sportsbookId,
LPAD(CONCAT('amounts_', CAST(ABS(RANDOM() % 10000) AS VARCHAR)), 81, '0') AS amounts,
'USD' AS currencyCode, -- Randomize as needed
RANDOM() * 100 AS jackpotContribution,
RANDOM() < 0.5 AS promotional, -- Boolean, 50% true/false
RANDOM() * 1000 AS amountReal_base,
LPAD(CONCAT('gameSession_', CAST(ABS(RANDOM() % 10000) AS VARCHAR)), 81, '0') AS providerGameSessionId,
RANDOM() * 1000 AS betslipWinnings_base,
RANDOM() * 1000 AS walletAmount_eur,
TIMESTAMPADD('SECOND', RANDOMINT(100000000), '2022-01-01 00:00:00') AS betslipSettledAt,
RANDOM() * 1000 AS jackpotAmount,
LPAD(CONCAT('provider_', CAST(ABS(RANDOM() % 10000) AS VARCHAR)), 81, '0') AS provider,
RANDOM() * 1000 AS balanceAfterBonus_base,
RANDOM() * 1000 AS amountReal,
RANDOM() * 1000 AS walletAmount_base,
RANDOM() * 1000 AS balanceAfterBonus_eur,
RANDOM() * 1000 AS balanceAfterReal_base,
RANDOM() * 1000 AS betslipWinnings,
LPAD(CONCAT('transactionType_', CAST(ABS(RANDOM() % 10000) AS VARCHAR)), 81, '0') AS gameTransactionType,
RANDOM() * 1000 AS walletAmount,
RANDOM() * 1000 AS balanceAfterReal,
RANDOM() < 0.5 AS discardable, -- Boolean
LPAD(CONCAT('message_', CAST(ABS(RANDOM() % 10000) AS VARCHAR)), 81, '0') AS message,
RANDOM() * 1000 AS amount,
RANDOM() * 1000 AS sportsbookWinnings_base,
RANDOM() * 1000 AS jackpotContribution_base,
TIMESTAMPADD('SECOND', RANDOMINT(100000000), '2022-01-01 00:00:00') AS updatedAt,
RANDOM() * 1000 AS availableBalanceAfterBonus_eur,
RANDOM() * 100 AS taxAmount_eur,
LPAD(CONCAT('gameRound_', CAST(ABS(RANDOM() % 10000) AS VARCHAR)), 81, '0') AS gameRoundId,
LPAD(CONCAT('providerGameTransaction_', CAST(ABS(RANDOM() % 10000) AS VARCHAR)), 81, '0') AS providerGameTransactionId,
RANDOM() * 1000 AS balanceAfter_base,
RANDOM() * 1000 AS sportsbookWinnings_eur,
RANDOM() * 1000 AS availableBalanceAfterBonus,
LPAD(CONCAT('code_', CAST(ABS(RANDOM() % 10000) AS VARCHAR)), 81, '0') AS code,
RANDOM() * 1000 AS amountReal_eur,
RANDOM() * 1000 AS availableBalanceAfter_eur,
LPAD(CONCAT('game_', CAST(ABS(RANDOM() % 10000) AS VARCHAR)), 81, '0') AS gameId,
LPAD(CONCAT('syndicate_', CAST(ABS(RANDOM() % 10000) AS VARCHAR)), 81, '0') AS syndicateSessionId,
LPAD(CONCAT('gameSession_', CAST(ABS(RANDOM() % 10000) AS VARCHAR)), 81, '0') AS gameSessionId,
RANDOM() * 1000 AS amount_eur,
LPAD(CONCAT('providerRound_', CAST(ABS(RANDOM() % 10000) AS VARCHAR)), 81, '0') AS providerRoundId,
LPAD(CONCAT('errorCode_', CAST(ABS(RANDOM() % 10000) AS VARCHAR)), 81, '0') AS errorCode,
RANDOM() * 1000 AS availableBalanceAfterReal,
LPAD(CONCAT('betslip_', CAST(ABS(RANDOM() % 10000) AS VARCHAR)), 81, '0') AS betslipId,
RANDOM() * 100 AS fxSpread,
RANDOM() * 1000 AS balanceAfter_eur,
TIMESTAMPADD('SECOND', RANDOMINT(100000000), '2022-01-01 00:00:00') AS processedAt,
LPAD(CONCAT('providerBetslip_', CAST(ABS(RANDOM() % 10000) AS VARCHAR)), 81, '0') AS providerBetslipId,
LPAD(CONCAT('status_', CAST(ABS(RANDOM() % 10000) AS VARCHAR)), 81, '0') AS betslipStatus,
'USD' AS walletCurrencyCode, -- Randomize if needed
1 + RANDOM() * 0.1 AS fxRate,
LPAD(CONCAT('transaction_', CAST(ABS(RANDOM() % 10000) AS VARCHAR)), 81, '0') AS gameTransactionId,
RANDOM() * 1000 AS providerAmount_base,
LPAD(CONCAT('sportsbookStatus_', CAST(ABS(RANDOM() % 10000) AS VARCHAR)), 81, '0') AS sportsbookStatus,
RANDOM() * 1000 AS balanceAfterReal_eur,
LPAD(CONCAT('reason_', CAST(ABS(RANDOM() % 10000) AS VARCHAR)), 81, '0') AS reason,
RANDOM() * 100 AS jackpotContribution_eur,
RANDOM() * 1000 AS amountBonus,
LPAD(CONCAT('providerSportsbook_', CAST(ABS(RANDOM() % 10000) AS VARCHAR)), 81, '0') AS providerSportsbookId,
RANDOM() * 1000 AS providerAmount_eur,
RANDOM() * 1000 AS balanceAfter,
LPAD(CONCAT('details_', CAST(ABS(RANDOM() % 10000) AS VARCHAR)), 81, '0') AS details,
TIMESTAMPADD('SECOND', RANDOMINT(100000000), '2022-01-01 00:00:00') AS createdAt,
LPAD(CONCAT('sportsbook_', CAST(ABS(RANDOM() % 10000) AS VARCHAR)), 81, '0') AS sportsbook,
LPAD(CONCAT('studio_', CAST(ABS(RANDOM() % 10000) AS VARCHAR)), 81, '0') AS studio,
RANDOM() * 1000 AS amountBonus_eur,
RANDOM() * 1000 AS availableBalanceAfterBonus_base,
LPAD(CONCAT('file_', CAST(ABS(RANDOM() % 10000) AS VARCHAR)), 81, '0') AS _CELONIS_INPUT_FILE,
ABS(RANDOM() % 10) AS version,
RANDOM() * 100 AS taxAmount_base,
RANDOM() * 1000 AS jackpotAmount_base,
LPAD(CONCAT('shop_', CAST(ABS(RANDOM() % 10000) AS VARCHAR)), 81, '0') AS shopRef,
RANDOM() * 100 AS taxAmount,
RANDOM() * 1000 AS jackpotAmount_eur,
TIMESTAMPADD('SECOND', RANDOMINT(100000000), '2022-01-01 00:00:00') AS succeededAt,
RANDOM() * 1000 AS sportsbookWinnings,
ABS(RANDOM() % 1000) AS gameRoundIndex,
LPAD(CONCAT('terminal_', CAST(ABS(RANDOM() % 10000) AS VARCHAR)), 81, '0') AS terminalRef,
RANDOM() * 1000 AS amountBonus_base,
LPAD(CONCAT('user_', CAST(ABS(RANDOM() % 10000) AS VARCHAR)), 81, '0') AS userId,
RANDOM() * 1000 AS balanceAfterBonus,
LPAD(CONCAT('betslip_', CAST(ABS(RANDOM() % 10000) AS VARCHAR)), 81, '0') AS betslip,
LPAD(CONCAT('reason_', CAST(ABS(RANDOM() % 10000) AS VARCHAR)), 81, '0') AS transactionReason,
RANDOM() * 1000 AS availableBalanceAfter_base,
RANDOM() * 1000 AS betslipWinnings_eur,
RANDOM() * 1000 AS availableBalanceAfterReal_eur,
RANDOM() * 1000 AS availableBalanceAfter,
LPAD(CONCAT('status_', CAST(ABS(RANDOM() % 10000) AS VARCHAR)), 81, '0') AS status,
LPAD(CONCAT('session_', CAST(ABS(RANDOM() % 10000) AS VARCHAR)), 81, '0') AS sessionId,
RANDOM() * 1000 AS amount_base
FROM (SELECT 1 FROM (SELECT 1 UNION ALL SELECT 2 UNION ALL SELECT 3 UNION ALL SELECT 4) t1
CROSS JOIN (SELECT 1 UNION ALL SELECT 2 UNION ALL SELECT 3 UNION ALL SELECT 4) t2
CROSS JOIN (SELECT 1 UNION ALL SELECT 2 UNION ALL SELECT 3 UNION ALL SELECT 4) t3
CROSS JOIN (SELECT 1 UNION ALL SELECT 2 UNION ALL SELECT 3 UNION ALL SELECT 4) t4
CROSS JOIN (SELECT 1 UNION ALL SELECT 2 UNION ALL SELECT 3 UNION ALL SELECT 4) t5
CROSS JOIN (SELECT 1 UNION ALL SELECT 2 UNION ALL SELECT 3 UNION ALL SELECT 4) t6
CROSS JOIN (SELECT 1 UNION ALL SELECT 2 UNION ALL SELECT 3 UNION ALL SELECT 4) t7
CROSS JOIN (SELECT 1 UNION ALL SELECT 2) t8
) temp
LIMIT 30000;
-- merge query
MERGE INTO "gametransaction" AS target
USING (
SELECT *
FROM "_CELONIS_TMP_gametransaction"
LIMIT 1 OVER (PARTITION BY "gameTransactionId" ORDER BY 1)
) input ON input."gameTransactionId" <=> target."gameTransactionId"
WHEN MATCHED THEN
UPDATE SET
"device" = input."device",
"promotionId" = input."promotionId",
"providerAmount" = input."providerAmount",
"availableBalanceAfterReal_base" = input."availableBalanceAfterReal_base",
"sportsbookId" = input."sportsbookId",
"amounts" = input."amounts",
"currencyCode" = input."currencyCode",
"jackpotContribution" = input."jackpotContribution",
"promotional" = input."promotional",
"amountReal_base" = input."amountReal_base",
"providerGameSessionId" = input."providerGameSessionId",
"betslipWinnings_base" = input."betslipWinnings_base",
"walletAmount_eur" = input."walletAmount_eur",
"betslipSettledAt" = input."betslipSettledAt",
"jackpotAmount" = input."jackpotAmount",
"provider" = input."provider",
"balanceAfterBonus_base" = input."balanceAfterBonus_base",
"amountReal" = input."amountReal",
"walletAmount_base" = input."walletAmount_base",
"balanceAfterBonus_eur" = input."balanceAfterBonus_eur",
"balanceAfterReal_base" = input."balanceAfterReal_base",
"betslipWinnings" = input."betslipWinnings",
"gameTransactionType" = input."gameTransactionType",
"walletAmount" = input."walletAmount",
"balanceAfterReal" = input."balanceAfterReal",
"discardable" = input."discardable",
"message" = input."message",
"amount" = input."amount",
"sportsbookWinnings_base" = input."sportsbookWinnings_base",
"jackpotContribution_base" = input."jackpotContribution_base",
"updatedAt" = input."updatedAt",
"availableBalanceAfterBonus_eur" = input."availableBalanceAfterBonus_eur",
"taxAmount_eur" = input."taxAmount_eur",
"gameRoundId" = input."gameRoundId",
"providerGameTransactionId" = input."providerGameTransactionId",
"balanceAfter_base" = input."balanceAfter_base",
"sportsbookWinnings_eur" = input."sportsbookWinnings_eur",
"availableBalanceAfterBonus" = input."availableBalanceAfterBonus",
"code" = input."code",
"amountReal_eur" = input."amountReal_eur",
"availableBalanceAfter_eur" = input."availableBalanceAfter_eur",
"gameId" = input."gameId",
"syndicateSessionId" = input."syndicateSessionId",
"gameSessionId" = input."gameSessionId",
"amount_eur" = input."amount_eur",
"providerRoundId" = input."providerRoundId",
"errorCode" = input."errorCode",
"availableBalanceAfterReal" = input."availableBalanceAfterReal",
"betslipId" = input."betslipId",
"fxSpread" = input."fxSpread",
"balanceAfter_eur" = input."balanceAfter_eur",
"processedAt" = input."processedAt",
"providerBetslipId" = input."providerBetslipId",
"betslipStatus" = input."betslipStatus",
"walletCurrencyCode" = input."walletCurrencyCode",
"fxRate" = input."fxRate",
"gameTransactionId" = input."gameTransactionId",
"providerAmount_base" = input."providerAmount_base",
"sportsbookStatus" = input."sportsbookStatus",
"balanceAfterReal_eur" = input."balanceAfterReal_eur",
"reason" = input."reason",
"jackpotContribution_eur" = input."jackpotContribution_eur",
"amountBonus" = input."amountBonus",
"providerSportsbookId" = input."providerSportsbookId",
"providerAmount_eur" = input."providerAmount_eur",
"balanceAfter" = input."balanceAfter",
"details" = input."details",
"createdAt" = input."createdAt",
"sportsbook" = input."sportsbook",
"studio" = input."studio",
"amountBonus_eur" = input."amountBonus_eur",
"availableBalanceAfterBonus_base" = input."availableBalanceAfterBonus_base",
"_CELONIS_INPUT_FILE" = input."_CELONIS_INPUT_FILE",
"version" = input."version",
"taxAmount_base" = input."taxAmount_base",
"jackpotAmount_base" = input."jackpotAmount_base",
"shopRef" = input."shopRef",
"taxAmount" = input."taxAmount",
"jackpotAmount_eur" = input."jackpotAmount_eur",
"succeededAt" = input."succeededAt",
"sportsbookWinnings" = input."sportsbookWinnings",
"gameRoundIndex" = input."gameRoundIndex",
"terminalRef" = input."terminalRef",
"amountBonus_base" = input."amountBonus_base",
"userId" = input."userId",
"balanceAfterBonus" = input."balanceAfterBonus",
"betslip" = input."betslip",
"transactionReason" = input."transactionReason",
"availableBalanceAfter_base" = input."availableBalanceAfter_base",
"betslipWinnings_eur" = input."betslipWinnings_eur",
"availableBalanceAfterReal_eur" = input."availableBalanceAfterReal_eur",
"availableBalanceAfter" = input."availableBalanceAfter",
"status" = input."status",
"sessionId" = input."sessionId",
"amount_base" = input."amount_base",
_CELONIS_CHANGE_DATE = CURRENT_TIMESTAMP(3)
WHEN NOT MATCHED THEN
INSERT (
"device", "promotionId", "providerAmount", "availableBalanceAfterReal_base",
"sportsbookId", "amounts", "currencyCode", "jackpotContribution", "promotional",
"amountReal_base", "providerGameSessionId", "betslipWinnings_base",
"walletAmount_eur", "betslipSettledAt", "jackpotAmount", "provider",
"balanceAfterBonus_base", "amountReal", "walletAmount_base",
"balanceAfterBonus_eur", "balanceAfterReal_base", "betslipWinnings",
"gameTransactionType", "walletAmount", "balanceAfterReal", "discardable",
"message", "amount", "sportsbookWinnings_base", "jackpotContribution_base",
"updatedAt", "availableBalanceAfterBonus_eur", "taxAmount_eur", "gameRoundId",
"providerGameTransactionId", "balanceAfter_base", "sportsbookWinnings_eur",
"availableBalanceAfterBonus", "code", "amountReal_eur", "availableBalanceAfter_eur",
"gameId", "syndicateSessionId", "gameSessionId", "amount_eur", "providerRoundId",
"errorCode", "availableBalanceAfterReal", "betslipId", "fxSpread", "balanceAfter_eur",
"processedAt", "providerBetslipId", "betslipStatus", "walletCurrencyCode",
"fxRate", "gameTransactionId", "providerAmount_base", "sportsbookStatus",
"balanceAfterReal_eur", "reason", "jackpotContribution_eur", "amountBonus",
"providerSportsbookId", "providerAmount_eur", "balanceAfter", "details",
"createdAt", "sportsbook", "studio", "amountBonus_eur", "availableBalanceAfterBonus_base",
"_CELONIS_INPUT_FILE", "version", "taxAmount_base", "jackpotAmount_base",
"shopRef", "taxAmount", "jackpotAmount_eur", "succeededAt", "sportsbookWinnings",
"gameRoundIndex", "terminalRef", "amountBonus_base", "userId", "balanceAfterBonus",
"betslip", "transactionReason", "availableBalanceAfter_base", "betslipWinnings_eur",
"availableBalanceAfterReal_eur", "availableBalanceAfter", "status", "sessionId",
"amount_base", _CELONIS_CHANGE_DATE
)
VALUES (
input."device", input."promotionId", input."providerAmount",
input."availableBalanceAfterReal_base", input."sportsbookId", input."amounts",
input."currencyCode", input."jackpotContribution", input."promotional",
input."amountReal_base", input."providerGameSessionId", input."betslipWinnings_base",
input."walletAmount_eur", input."betslipSettledAt", input."jackpotAmount",
input."provider", input."balanceAfterBonus_base", input."amountReal",
input."walletAmount_base", input."balanceAfterBonus_eur", input."balanceAfterReal_base",
input."betslipWinnings", input."gameTransactionType", input."walletAmount",
input."balanceAfterReal", input."discardable", input."message", input."amount",
input."sportsbookWinnings_base", input."jackpotContribution_base", input."updatedAt",
input."availableBalanceAfterBonus_eur", input."taxAmount_eur", input."gameRoundId",
input."providerGameTransactionId", input."balanceAfter_base", input."sportsbookWinnings_eur",
input."availableBalanceAfterBonus", input."code", input."amountReal_eur",
input."availableBalanceAfter_eur", input."gameId", input."syndicateSessionId",
input."gameSessionId", input."amount_eur", input."providerRoundId", input."errorCode",
input."availableBalanceAfterReal", input."betslipId", input."fxSpread",
input."balanceAfter_eur", input."processedAt", input."providerBetslipId",
input."betslipStatus", input."walletCurrencyCode", input."fxRate",
input."gameTransactionId", input."providerAmount_base", input."sportsbookStatus",
input."balanceAfterReal_eur", input."reason", input."jackpotContribution_eur",
input."amountBonus", input."providerSportsbookId", input."providerAmount_eur",
input."balanceAfter", input."details", input."createdAt", input."sportsbook",
input."studio", input."amountBonus_eur", input."availableBalanceAfterBonus_base",
input."_CELONIS_INPUT_FILE", input."version", input."taxAmount_base",
input."jackpotAmount_base", input."shopRef", input."taxAmount",
input."jackpotAmount_eur", input."succeededAt", input."sportsbookWinnings",
input."gameRoundIndex", input."terminalRef", input."amountBonus_base",
input."userId", input."balanceAfterBonus", input."betslip", input."transactionReason",
input."availableBalanceAfter_base", input."betslipWinnings_eur",
input."availableBalanceAfterReal_eur", input."availableBalanceAfter",
input."status", input."sessionId", input."amount_base", CURRENT_TIMESTAMP(3)
);
Raw
query plan
------------------------------
QUERY PLAN DESCRIPTION:
------------------------------
""
"EXPLAIN MERGE INTO ""gametransaction"" AS target USING ( SELECT * FROM ""_CELONIS_TMP_gametransaction"" LIMIT 1 OVER (PARTITION BY ""gameTransactionId"" ORDER BY 1) ) input ON input.""gameTransactionId"" <=> target.""gameTransactionId"" WHEN MATCHED THEN UPDATE SET ""device"" = input.""device"", ""promotionId"" = input.""promotionId"", ""providerAmount"" = input.""providerAmount"", ""availableBalanceAfterReal_base"" = input.""availableBalanceAfterReal_base"", ""sportsbookId"" = input.""sportsbookId"", ""amounts"" = input.""amounts"", ""currencyCode"" = input.""currencyCode"", ""jackpotContribution"" = input.""jackpotContribution"", ""promotional"" = input.""promotional"", ""amountReal_base"" = input.""amountReal_base"", ""providerGameSessionId"" = input.""providerGameSessionId"", ""betslipWinnings_base"" = input.""betslipWinnings_base"", ""walletAmount_eur"" = input.""walletAmount_eur"", ""betslipSettledAt"" = input.""betslipSettledAt"", ""jackpotAmount"" = input.""jackpotAmount"", ""provider"" = input.""provider"", ""balanceAfterBonus_base"" = input.""balanceAfterBonus_base"", ""amountReal"" = input.""amountReal"", ""walletAmount_base"" = input.""walletAmount_base"", ""balanceAfterBonus_eur"" = input.""balanceAfterBonus_eur"", ""balanceAfterReal_base"" = input.""balanceAfterReal_base"", ""betslipWinnings"" = input.""betslipWinnings"", ""gameTransactionType"" = input.""gameTransactionType"", ""walletAmount"" = input.""walletAmount"", ""balanceAfterReal"" = input.""balanceAfterReal"", ""discardable"" = input.""discardable"", ""message"" = input.""message"", ""amount"" = input.""amount"", ""sportsbookWinnings_base"" = input.""sportsbookWinnings_base"", ""jackpotContribution_base"" = input.""jackpotContribution_base"", ""updatedAt"" = input.""updatedAt"", ""availableBalanceAfterBonus_eur"" = input.""availableBalanceAfterBonus_eur"", ""taxAmount_eur"" = input.""taxAmount_eur"", ""gameRoundId"" = input.""gameRoundId"", ""providerGameTransactionId"" = input.""providerGameTransactionId"", ""balanceAfter_base"" = input.""balanceAfter_base"", ""sportsbookWinnings_eur"" = input.""sportsbookWinnings_eur"", ""availableBalanceAfterBonus"" = input.""availableBalanceAfterBonus"", ""code"" = input.""code"", ""amountReal_eur"" = input.""amountReal_eur"", ""availableBalanceAfter_eur"" = input.""availableBalanceAfter_eur"", ""gameId"" = input.""gameId"", ""syndicateSessionId"" = input.""syndicateSessionId"", ""gameSessionId"" = input.""gameSessionId"", ""amount_eur"" = input.""amount_eur"", ""providerRoundId"" = input.""providerRoundId"", ""errorCode"" = input.""errorCode"", ""availableBalanceAfterReal"" = input.""availableBalanceAfterReal"", ""betslipId"" = input.""betslipId"", ""fxSpread"" = input.""fxSpread"", ""balanceAfter_eur"" = input.""balanceAfter_eur"", ""processedAt"" = input.""processedAt"", ""providerBetslipId"" = input.""providerBetslipId"", ""betslipStatus"" = input.""betslipStatus"", ""walletCurrencyCode"" = input.""walletCurrencyCode"", ""fxRate"" = input.""fxRate"", ""gameTransactionId"" = input.""gameTransactionId"", ""providerAmount_base"" = input.""providerAmount_base"", ""sportsbookStatus"" = input.""sportsbookStatus"", ""balanceAfterReal_eur"" = input.""balanceAfterReal_eur"", ""reason"" = input.""reason"", ""jackpotContribution_eur"" = input.""jackpotContribution_eur"", ""amountBonus"" = input.""amountBonus"", ""providerSportsbookId"" = input.""providerSportsbookId"", ""providerAmount_eur"" = input.""providerAmount_eur"", ""balanceAfter"" = input.""balanceAfter"", ""details"" = input.""details"", ""createdAt"" = input.""createdAt"", ""sportsbook"" = input.""sportsbook"", ""studio"" = input.""studio"", ""amountBonus_eur"" = input.""amountBonus_eur"", ""availableBalanceAfterBonus_base"" = input.""availableBalanceAfterBonus_base"", ""_CELONIS_INPUT_FILE"" = input.""_CELONIS_INPUT_FILE"", ""version"" = input.""version"", ""taxAmount_base"" = input.""taxAmount_base"", ""jackpotAmount_base"" = input.""jackpotAmount_base"", ""shopRef"" = input.""shopRef"", ""taxAmount"" = input.""taxAmount"", ""jackpotAmount_eur"" = input.""jackpotAmount_eur"", ""succeededAt"" = input.""succeededAt"", ""sportsbookWinnings"" = input.""sportsbookWinnings"", ""gameRoundIndex"" = input.""gameRoundIndex"", ""terminalRef"" = input.""terminalRef"", ""amountBonus_base"" = input.""amountBonus_base"", ""userId"" = input.""userId"", ""balanceAfterBonus"" = input.""balanceAfterBonus"", ""betslip"" = input.""betslip"", ""transactionReason"" = input.""transactionReason"", ""availableBalanceAfter_base"" = input.""availableBalanceAfter_base"", ""betslipWinnings_eur"" = input.""betslipWinnings_eur"", ""availableBalanceAfterReal_eur"" = input.""availableBalanceAfterReal_eur"", ""availableBalanceAfter"" = input.""availableBalanceAfter"", ""status"" = input.""status"", ""sessionId"" = input.""sessionId"", ""amount_base"" = input.""amount_base"", _CELONIS_CHANGE_DATE = CURRENT_TIMESTAMP(3) WHEN NOT MATCHED THEN INSERT ( ""device"", ""promotionId"", ""providerAmount"", ""availableBalanceAfterReal_base"", ""sportsbookId"", ""amounts"", ""currencyCode"", ""jackpotContribution"", ""promotional"", ""amountReal_base"", ""providerGameSessionId"", ""betslipWinnings_base"", ""walletAmount_eur"", ""betslipSettledAt"", ""jackpotAmount"", ""provider"", ""balanceAfterBonus_base"", ""amountReal"", ""walletAmount_base"", ""balanceAfterBonus_eur"", ""balanceAfterReal_base"", ""betslipWinnings"", ""gameTransactionType"", ""walletAmount"", ""balanceAfterReal"", ""discardable"", ""message"", ""amount"", ""sportsbookWinnings_base"", ""jackpotContribution_base"", ""updatedAt"", ""availableBalanceAfterBonus_eur"", ""taxAmount_eur"", ""gameRoundId"", ""providerGameTransactionId"", ""balanceAfter_base"", ""sportsbookWinnings_eur"", ""availableBalanceAfterBonus"", ""code"", ""amountReal_eur"", ""availableBalanceAfter_eur"", ""gameId"", ""syndicateSessionId"", ""gameSessionId"", ""amount_eur"", ""providerRoundId"", ""errorCode"", ""availableBalanceAfterReal"", ""betslipId"", ""fxSpread"", ""balanceAfter_eur"", ""processedAt"", ""providerBetslipId"", ""betslipStatus"", ""walletCurrencyCode"", ""fxRate"", ""gameTransactionId"", ""providerAmount_base"", ""sportsbookStatus"", ""balanceAfterReal_eur"", ""reason"", ""jackpotContribution_eur"", ""amountBonus"", ""providerSportsbookId"", ""providerAmount_eur"", ""balanceAfter"", ""details"", ""createdAt"", ""sportsbook"", ""studio"", ""amountBonus_eur"", ""availableBalanceAfterBonus_base"", ""_CELONIS_INPUT_FILE"", ""version"", ""taxAmount_base"", ""jackpotAmount_base"", ""shopRef"", ""taxAmount"", ""jackpotAmount_eur"", ""succeededAt"", ""sportsbookWinnings"", ""gameRoundIndex"", ""terminalRef"", ""amountBonus_base"", ""userId"", ""balanceAfterBonus"", ""betslip"", ""transactionReason"", ""availableBalanceAfter_base"", ""betslipWinnings_eur"", ""availableBalanceAfterReal_eur"", ""availableBalanceAfter"", ""status"", ""sessionId"", ""amount_base"", _CELONIS_CHANGE_DATE ) VALUES ( input.""device"", input.""promotionId"", input.""providerAmount"", input.""availableBalanceAfterReal_base"", input.""sportsbookId"", input.""amounts"", input.""currencyCode"", input.""jackpotContribution"", input.""promotional"", input.""amountReal_base"", input.""providerGameSessionId"", input.""betslipWinnings_base"", input.""walletAmount_eur"", input.""betslipSettledAt"", input.""jackpotAmount"", input.""provider"", input.""balanceAfterBonus_base"", input.""amountReal"", input.""walletAmount_base"", input.""balanceAfterBonus_eur"", input.""balanceAfterReal_base"", input.""betslipWinnings"", input.""gameTransactionType"", input.""walletAmount"", input.""balanceAfterReal"", input.""discardable"", input.""message"", input.""amount"", input.""sportsbookWinnings_base"", input.""jackpotContribution_base"", input.""updatedAt"", input.""availableBalanceAfterBonus_eur"", input.""taxAmount_eur"", input.""gameRoundId"", input.""providerGameTransactionId"", input.""balanceAfter_base"", input.""sportsbookWinnings_eur"", input.""availableBalanceAfterBonus"", input.""code"", input.""amountReal_eur"", input.""availableBalanceAfter_eur"", input.""gameId"", input.""syndicateSessionId"", input.""gameSessionId"", input.""amount_eur"", input.""providerRoundId"", input.""errorCode"", input.""availableBalanceAfterReal"", input.""betslipId"", input.""fxSpread"", input.""balanceAfter_eur"", input.""processedAt"", input.""providerBetslipId"", input.""betslipStatus"", input.""walletCurrencyCode"", input.""fxRate"", input.""gameTransactionId"", input.""providerAmount_base"", input.""sportsbookStatus"", input.""balanceAfterReal_eur"", input.""reason"", input.""jackpotContribution_eur"", input.""amountBonus"", input.""providerSportsbookId"", input.""providerAmount_eur"", input.""balanceAfter"", input.""details"", input.""createdAt"", input.""sportsbook"", input.""studio"", input.""amountBonus_eur"", input.""availableBalanceAfterBonus_base"", input.""_CELONIS_INPUT_FILE"", input.""version"", input.""taxAmount_base"", input.""jackpotAmount_base"", input.""shopRef"", input.""taxAmount"", input.""jackpotAmount_eur"", input.""succeededAt"", input.""sportsbookWinnings"", input.""gameRoundIndex"", input.""terminalRef"", input.""amountBonus_base"", input.""userId"", input.""balanceAfterBonus"", input.""betslip"", input.""transactionReason"", input.""availableBalanceAfter_base"", input.""betslipWinnings_eur"", input.""availableBalanceAfterReal_eur"", input.""availableBalanceAfter"", input.""status"", input.""sessionId"", input.""amount_base"", CURRENT_TIMESTAMP(3) );"
""
Access Path:
"+-DML MERGE [Cost: 0, Rows: 0]"
| Target Projection: public.gametransaction_super
| Target Projection: public.gametransaction_PK
| Target Prep:
"| +---> JOIN HASH [RightOuter] [Cost: 132K, Rows: 10K (NO STATISTICS)] (PATH ID: 1)"
| | Join Cond: (VAL(2) <=> gametransaction.gameTransactionId)
"| | +-- Outer -> STORAGE ACCESS for <No Alias> [Cost: 63K, Rows: 10K (NO STATISTICS)] (PATH ID: 2)"
| | | Projection: public.gametransaction_super
"| | | Materialize: gametransaction.amountReal_eur, gametransaction.gameTransactionId, gametransaction.jackpotAmount_base, gametransaction.walletAmount, gametransaction.betslipId, gametransaction.reason, gametransaction.jackpotContribution_base, gametransaction.providerSportsbookId, gametransaction.balanceAfter_eur, gametransaction.fxSpread, gametransaction.jackpotAmount, gametransaction.sportsbook, gametransaction.providerAmount, gametransaction.amount_eur, gametransaction.availableBalanceAfter_base, gametransaction.availableBalanceAfterBonus_eur, gametransaction.availableBalanceAfterReal_base, gametransaction.availableBalanceAfterBonus_base, gametransaction.balanceAfterBonus_base, gametransaction.amountBonus, gametransaction.details, gametransaction.providerGameTransactionId, gametransaction.walletAmount_eur, gametransaction.discardable, gametransaction._CELONIS_INPUT_FILE, gametransaction.jackpotContribution, gametransaction.terminalRef, gametransaction.shopRef, gametransaction.sportsbookWinnings_base, gametransaction.fxRate, gametransaction.availableBalanceAfter_eur, gametransaction.balanceAfter_base, gametransaction.sessionId, gametransaction.status, gametransaction.sportsbookWinnings_eur, gametransaction.betslipSettledAt, gametransaction.sportsbookStatus, gametransaction.balanceAfter, gametransaction.transactionReason, gametransaction.betslip, gametransaction.taxAmount, gametransaction.device, gametransaction.succeededAt, gametransaction.promotionId, gametransaction.sportsbookId, gametransaction.taxAmount_eur, gametransaction.taxAmount_base, gametransaction.availableBalanceAfterBonus, gametransaction.version, gametransaction.promotional, gametransaction.balanceAfterBonus, gametransaction.gameTransactionType, gametransaction.providerGameSessionId, gametransaction.currencyCode, gametransaction.amount, gametransaction.userId, gametransaction.providerAmount_eur, gametransaction.jackpotContribution_eur, gametransaction.errorCode, gametransaction.message, gametransaction.walletAmount_base, gametransaction.processedAt, gametransaction.provider, gametransaction.syndicateSessionId, gametransaction.betslipWinnings_eur, gametransaction.availableBalanceAfterReal, gametransaction.gameRoundId, gametransaction.betslipStatus, gametransaction.balanceAfterReal, gametransaction.studio, gametransaction.availableBalanceAfterReal_eur, gametransaction.amountReal_base, gametransaction.betslipWinnings_base, gametransaction.updatedAt, gametransaction.gameSessionId, gametransaction.amountBonus_base, gametransaction.code, gametransaction.providerAmount_base, gametransaction.providerRoundId, gametransaction.providerBetslipId, gametransaction.amount_base, gametransaction.balanceAfterReal_base, gametransaction.availableBalanceAfter, gametransaction.gameRoundIndex, gametransaction.balanceAfterReal_eur, gametransaction.jackpotAmount_eur, gametransaction.amountReal, gametransaction.betslipWinnings, gametransaction.sportsbookWinnings, gametransaction.createdAt, gametransaction.amounts, gametransaction.gameId, gametransaction.balanceAfterBonus_eur, gametransaction.amountBonus_eur, gametransaction.walletCurrencyCode, gametransaction._CELONIS_CHANGE_DATE, gametransaction.epoch"
| | | Runtime Filter: (SIP1(HashJoin): gametransaction.gameTransactionId)
"| | +-- Inner -> SELECT [Cost: 64K, Rows: 10K (NO STATISTICS)] (PATH ID: 3)"
"| | | +---> SELECT LIMIT 1 [Cost: 64K, Rows: 10K (NO STATISTICS)] (PATH ID: 4)"
"| | | | +---> ANALYTICAL [Cost: 64K, Rows: 10K (NO STATISTICS)] (PATH ID: 5)"
| | | | | Analytic Group
| | | | | Functions: row_number()
| | | | | Group Local Resegment: _CELONIS_TMP_gametransaction.gameTransactionId
"| | | | | Group Sort: _CELONIS_TMP_gametransaction.gameTransactionId ASC, 1 ASC NULLS LAST"
"| | | | | TopK Optimized: K=1, PB Cols = 1"
| | | | | Output Only: 1 tuples
"| | | | | +---> STORAGE ACCESS for _CELONIS_TMP_gametransaction [Cost: 59K, Rows: 10K (NO STATISTICS)] (PATH ID: 6)"
| | | | | | Projection: v_temp_schema._CELONIS_TMP_gametransaction_super
"| | | | | | Materialize: _CELONIS_TMP_gametransaction.device, _CELONIS_TMP_gametransaction.promotionId, _CELONIS_TMP_gametransaction.providerAmount, _CELONIS_TMP_gametransaction.availableBalanceAfterReal_base, _CELONIS_TMP_gametransaction.sportsbookId, _CELONIS_TMP_gametransaction.amounts, _CELONIS_TMP_gametransaction.currencyCode, _CELONIS_TMP_gametransaction.jackpotContribution, _CELONIS_TMP_gametransaction.promotional, _CELONIS_TMP_gametransaction.amountReal_base, _CELONIS_TMP_gametransaction.providerGameSessionId, _CELONIS_TMP_gametransaction.betslipWinnings_base, _CELONIS_TMP_gametransaction.walletAmount_eur, _CELONIS_TMP_gametransaction.betslipSettledAt, _CELONIS_TMP_gametransaction.jackpotAmount, _CELONIS_TMP_gametransaction.provider, _CELONIS_TMP_gametransaction.balanceAfterBonus_base, _CELONIS_TMP_gametransaction.amountReal, _CELONIS_TMP_gametransaction.walletAmount_base, _CELONIS_TMP_gametransaction.balanceAfterBonus_eur, _CELONIS_TMP_gametransaction.balanceAfterReal_base, _CELONIS_TMP_gametransaction.betslipWinnings, _CELONIS_TMP_gametransaction.gameTransactionType, _CELONIS_TMP_gametransaction.walletAmount, _CELONIS_TMP_gametransaction.balanceAfterReal, _CELONIS_TMP_gametransaction.discardable, _CELONIS_TMP_gametransaction.message, _CELONIS_TMP_gametransaction.amount, _CELONIS_TMP_gametransaction.sportsbookWinnings_base, _CELONIS_TMP_gametransaction.jackpotContribution_base, _CELONIS_TMP_gametransaction.updatedAt, _CELONIS_TMP_gametransaction.availableBalanceAfterBonus_eur, _CELONIS_TMP_gametransaction.taxAmount_eur, _CELONIS_TMP_gametransaction.gameRoundId, _CELONIS_TMP_gametransaction.providerGameTransactionId, _CELONIS_TMP_gametransaction.balanceAfter_base, _CELONIS_TMP_gametransaction.sportsbookWinnings_eur, _CELONIS_TMP_gametransaction.availableBalanceAfterBonus, _CELONIS_TMP_gametransaction.code, _CELONIS_TMP_gametransaction.amountReal_eur, _CELONIS_TMP_gametransaction.availableBalanceAfter_eur, _CELONIS_TMP_gametransaction.gameId, _CELONIS_TMP_gametransaction.syndicateSessionId, _CELONIS_TMP_gametransaction.gameSessionId, _CELONIS_TMP_gametransaction.amount_eur, _CELONIS_TMP_gametransaction.providerRoundId, _CELONIS_TMP_gametransaction.errorCode, _CELONIS_TMP_gametransaction.availableBalanceAfterReal, _CELONIS_TMP_gametransaction.betslipId, _CELONIS_TMP_gametransaction.fxSpread, _CELONIS_TMP_gametransaction.balanceAfter_eur, _CELONIS_TMP_gametransaction.processedAt, _CELONIS_TMP_gametransaction.providerBetslipId, _CELONIS_TMP_gametransaction.betslipStatus, _CELONIS_TMP_gametransaction.walletCurrencyCode, _CELONIS_TMP_gametransaction.fxRate, _CELONIS_TMP_gametransaction.gameTransactionId, _CELONIS_TMP_gametransaction.providerAmount_base, _CELONIS_TMP_gametransaction.sportsbookStatus, _CELONIS_TMP_gametransaction.balanceAfterReal_eur, _CELONIS_TMP_gametransaction.reason, _CELONIS_TMP_gametransaction.jackpotContribution_eur, _CELONIS_TMP_gametransaction.amountBonus, _CELONIS_TMP_gametransaction.providerSportsbookId, _CELONIS_TMP_gametransaction.providerAmount_eur, _CELONIS_TMP_gametransaction.balanceAfter, _CELONIS_TMP_gametransaction.details, _CELONIS_TMP_gametransaction.createdAt, _CELONIS_TMP_gametransaction.sportsbook, _CELONIS_TMP_gametransaction.studio, _CELONIS_TMP_gametransaction.amountBonus_eur, _CELONIS_TMP_gametransaction.availableBalanceAfterBonus_base, _CELONIS_TMP_gametransaction._CELONIS_INPUT_FILE, _CELONIS_TMP_gametransaction.version, _CELONIS_TMP_gametransaction.taxAmount_base, _CELONIS_TMP_gametransaction.jackpotAmount_base, _CELONIS_TMP_gametransaction.shopRef, _CELONIS_TMP_gametransaction.taxAmount, _CELONIS_TMP_gametransaction.jackpotAmount_eur, _CELONIS_TMP_gametransaction.succeededAt, _CELONIS_TMP_gametransaction.sportsbookWinnings, _CELONIS_TMP_gametransaction.gameRoundIndex, _CELONIS_TMP_gametransaction.terminalRef, _CELONIS_TMP_gametransaction.amountBonus_base, _CELONIS_TMP_gametransaction.userId, _CELONIS_TMP_gametransaction.balanceAfterBonus, _CELONIS_TMP_gametransaction.betslip, _CELONIS_TMP_gametransaction.transactionReason, _CELONIS_TMP_gametransaction.availableBalanceAfter_base, _CELONIS_TMP_gametransaction.betslipWinnings_eur, _CELONIS_TMP_gametransaction.availableBalanceAfterReal_eur, _CELONIS_TMP_gametransaction.availableBalanceAfter, _CELONIS_TMP_gametransaction.status, _CELONIS_TMP_gametransaction.sessionId, _CELONIS_TMP_gametransaction.amount_base"
""
""
------------------------------
-----------------------------------------------
PLAN: BASE QUERY PLAN (GraphViz Format)
-----------------------------------------------
digraph G {
"graph [rankdir=BT, label = ""BASE QUERY PLAN\nQuery: EXPLAIN MERGE INTO \""gametransaction\"" AS target USING ( SELECT * FROM \""_CELONIS_TMP_gametransaction\"" LIMIT 1 OVER (PARTITION BY \""gameTransactionId\"" ORDER BY 1) ) input ON input.\""gameTransactionId\"" \<=\> target.\""gameTransactionId\"" WHEN MATCHED THEN UPDATE SET \""device\"" = input.\""device\"", \""promotionId\"" = input.\""promotionId\"", \""providerAmount\"" = input.\""providerAmount\"", \""availableBalanceAfterReal_base\"" = input.\""availableBalanceAfterReal_base\"", \""sportsbookId\"" = input.\""sportsbookId\"", \""amounts\"" = input.\""amounts\"", \""currencyCode\"" = input.\""currencyCode\"", \""jackpotContribution\"" = input.\""jackpotContribution\"", \""promotional\"" = input.\""promotional\"", \""amountReal_base\"" = input.\""amountReal_base\"", \""providerGameSessionId\"" = input.\""providerGameSessionId\"", \""betslipWinnings_base\"" = input.\""betslipWinnings_base\"", \""walletAmount_eur\"" = input.\""walletAmount_eur\"", \""betslipSettledAt\"" = input.\""betslipSettledAt\"", \""jackpotAmount\"" = input.\""jackpotAmount\"", \""provider\"" = input.\""provider\"", \""balanceAfterBonus_base\"" = input.\""balanceAfterBonus_base\"", \""amountReal\"" = input.\""amountReal\"", \""walletAmount_base\"" = input.\""walletAmount_base\"", \""balanceAfterBonus_eur\"" = input.\""balanceAfterBonus_eur\"", \""balanceAfterReal_base\"" = input.\""balanceAfterReal_base\"", \""betslipWinnings\"" = input.\""betslipWinnings\"", \""gameTransactionType\"" = input.\""gameTransactionType\"", \""walletAmount\"" = input.\""walletAmount\"", \""balanceAfterReal\"" = input.\""balanceAfterReal\"", \""discardable\"" = input.\""discardable\"", \""message\"" = input.\""message\"", \""amount\"" = input.\""amount\"", \""sportsbookWinnings_base\"" = input.\""sportsbookWinnings_base\"", \""jackpotContribution_base\"" = input.\""jackpotContribution_base\"", \""updatedAt\"" = input.\""updatedAt\"", \""availableBalanceAfterBonus_eur\"" = input.\""availableBalanceAfterBonus_eur\"", \""taxAmount_eur\"" = input.\""taxAmount_eur\"", \""gameRoundId\"" = input.\""gameRoundId\"", \""providerGameTransactionId\"" = input.\""providerGameTransactionId\"", \""balanceAfter_base\"" = input.\""balanceAfter_base\"", \""sportsbookWinnings_eur\"" = input.\""sportsbookWinnings_eur\"", \""availableBalanceAfterBonus\"" = input.\""availableBalanceAfterBonus\"", \""code\"" = input.\""code\"", \""amountReal_eur\"" = input.\""amountReal_eur\"", \""availableBalanceAfter_eur\"" = input.\""availableBalanceAfter_eur\"", \""gameId\"" = input.\""gameId\"", \""syndicateSessionId\"" = input.\""syndicateSessionId\"", \""gameSessionId\"" = input.\""gameSessionId\"", \""amount_eur\"" = input.\""amount_eur\"", \""providerRoundId\"" = input.\""providerRoundId\"", \""errorCode\"" = input.\""...\nAll Nodes Vector: \n\n node[0]=v_vmart_node0001 (initiator) Up\n\nParticipating subscriptions: \n\n replica: [<0>]\n segment0001: [<0>]\n segment0002: [<0>]\n segment0003: [<0>]\n"", labelloc=t, labeljust=l ordering=out]"
"0[label = ""Root \nOutBlk=[UncTuple]"", color = ""green"", shape = ""house""];"
"1[label = ""NewEENode \nOutBlk=[UncTuple(195)]"", color = ""green"", shape = ""box""];"
"2[label = ""ExprEval: \n gametransaction.amountReal_eur\n gametransaction.gameTransactionId\n gametransaction.jackpotAmount_base\n gametransaction.walletAmount\n gametransaction.betslipId\n gametransaction.reason\n gametransaction.jackpotContribution_base\n gametransaction.providerSportsbookId\n gametransaction.balanceAfter_eur\n gametransaction.fxSpread\n gametransaction.jackpotAmount\n gametransaction.sportsbook\n gametransaction.providerAmount\n gametransaction.amount_eur\n gametransaction.availableBalanceAfter_base\n gametransaction.availableBalanceAfterBonus_eur\n gametransaction.availableBalanceAfterReal_base\n gametransaction.availableBalanceAfterBonus_base\n gametransaction.balanceAfterBonus_base\n gametransaction.amountBonus\n gametransaction.details\n gametransaction.providerGameTransactionId\n gametransaction.walletAmount_eur\n gametransaction.discardable\n gametransaction._CELONIS_INPUT_FILE\n gametransaction.jackpotContribution\n gametransaction.terminalRef\n gametransaction.shopRef\n gametransaction.sportsbookWinnings_base\n gametransaction.fxRate\n gametransaction.availableBalanceAfter_eur\n gametransaction.balanceAfter_base\n gametransaction.sessionId\n gametransaction.status\n gametransaction.sportsbookWinnings_eur\n gametransaction.betslipSettledAt\n gametransaction.sportsbookStatus\n gametransaction.balanceAfter\n gametransaction.transactionReason\n gametransaction.betslip\n gametransaction.taxAmount\n gametransaction.device\n gametransaction.succeededAt\n gametransaction.promotionId\n gametransaction.sportsbookId\n gametransaction.taxAmount_eur\n gametransaction.taxAmount_base\n gametransaction.availableBalanceAfterBonus\n gametransaction.version\n gametransaction.promotional\n gametransaction.balanceAfterBonus\n gametransaction.gameTransactionType\n gametransaction.providerGameSessionId\n gametransaction.currencyCode\n gametransaction.amount\n gametransaction.userId\n gametransaction.providerAmount_eur\n gametransaction.jackpotContribution_eur\n gametransaction.errorCode\n gametransaction.message\n gametransaction.walletAmount_base\n gametransaction.processedAt\n gametransaction.provider\n gametransaction.syndicateSessionId\n gametransaction.betslipWinnings_eur\n gametransaction.availableBalanceAfterReal\n gametransaction.gameRoundId\n gametransaction.betslipStatus\n gametransaction.balanceAfterReal\n gametransaction.studio\n gametransaction.availableBalanceAfterReal_eur\n gametransaction.amountReal_base\n gametransaction.betslipWinnings_base\n gametransaction.updatedAt\n gametransaction.gameSessionId\n gametransaction.amountBonus_base\n gametransaction.code\n gametransaction.providerAmount_base\n gametransaction.providerRoundId\n gametransaction.providerBetslipId\n gametransaction.amount_base\n gametransaction.balanceAfterReal_base\n gametransaction.availableBalanceAfter\n gametransaction.gameRoundIndex\n gametransaction.balanceAfterReal_eur\n gametransaction.jackpotAmount_eur\n gametransaction.amountReal\n gametransaction.betslipWinnings\n gametransaction.sportsbookWinnings\n gametransaction.createdAt\n gametransaction.amounts\n gametransaction.gameId\n gametransaction.balanceAfterBonus_eur\n gametransaction.amountBonus_eur\n gametransaction.walletCurrencyCode\n gametransaction._CELONIS_CHANGE_DATE\n gametransaction.epoch\n VAL(2)\n VAL(2)\n VAL(2)\n VAL(2)\n VAL(2)\n VAL(2)\n VAL(2)\n VAL(2)\n VAL(2)\n VAL(2)\n VAL(2)\n VAL(2)\n VAL(2)\n VAL(2)\n VAL(2)\n VAL(2)\n VAL(2)\n VAL(2)\n VAL(2)\n VAL(2)\n VAL(2)\n VAL(2)\n VAL(2)\n VAL(2)\n VAL(2)\n VAL(2)\n VAL(2)\n VAL(2)\n VAL(2)\n VAL(2)\n VAL(2)\n VAL(2)\n VAL(2)\n VAL(2)\n VAL(2)\n VAL(2)\n VAL(2)\n VAL(2)\n VAL(2)\n VAL(2)\n VAL(2)\n VAL(2)\n VAL(2)\n VAL(2)\n VAL(2)\n VAL(2)\n VAL(2)\n VAL(2)\n VAL(2)\n VAL(2)\n VAL(2)\n VAL(2)\n VAL(2)\n VAL(2)\n VAL(2)\n VAL(2)\n VAL(2)\n VAL(2)\n VAL(2)\n VAL(2)\n VAL(2)\n VAL(2)\n VAL(2)\n VAL(2)\n VAL(2)\n VAL(2)\n VAL(2)\n VAL(2)\n VAL(2)\n VAL(2)\n VAL(2)\n VAL(2)\n VAL(2)\n VAL(2)\n VAL(2)\n VAL(2)\n VAL(2)\n VAL(2)\n VAL(2)\n VAL(2)\n VAL(2)\n VAL(2)\n VAL(2)\n VAL(2)\n VAL(2)\n VAL(2)\n VAL(2)\n VAL(2)\n VAL(2)\n VAL(2)\n VAL(2)\n VAL(2)\n VAL(2)\n VAL(2)\n VAL(2)\n (now())::timestamptz(3)\n (-9223372036854775808)\n VAL(2)\nUnc: Float(8)\nUnc: Varchar(255)\nUnc: Float(8)\nUnc: Float(8)\nUnc: Varchar(255)\nUnc: Varchar(255)\nUnc: Float(8)\nUnc: Varchar(255)\nUnc: Float(8)\nUnc: Float(8)\nUnc: Float(8)\nUnc: Varchar(255)\nUnc: Float(8)\nUnc: Float(8)\nUnc: Float(8)\nUnc: Float(8)\nUnc: Float(8)\nUnc: Float(8)\nUnc: Float(8)\nUnc: Float(8)\nUnc: Varchar(255)\nUnc: Varchar(255)\nUnc: Float(8)\nUnc: Boolean(1)\nUnc: Varchar(255)\nUnc: Float(8)\nUnc: Varchar(255)\nUnc: Varchar(255)\nUnc: Float(8)\nUnc: Float(8)\nUnc: Float(8)\nUnc: Float(8)\nUnc: Varchar(255)\nUnc: Varchar(255)\nUnc: Float(8)\nUnc: Timestamp(8)\nUnc: Varchar(255)\nUnc: Float(8)\nUnc: Varchar(255)\nUnc: Varchar(255)\nUnc: Float(8)\nUnc: Varchar(255)\nUnc: Timestamp(8)\nUnc: Varchar(255)\nUnc: Varchar(255)\nUnc: Float(8)\nUnc: Float(8)\nUnc: Float(8)\nUnc: Integer(8)\nUnc: Boolean(1)\nUnc: Float(8)\nUnc: Varchar(255)\nUnc: Varchar(255)\nUnc: Varchar(255)\nUnc: Float(8)\nUnc: Varchar(255)\nUnc: Float(8)\nUnc: Float(8)\nUnc: Varchar(255)\nUnc: Varchar(255)\nUnc: Float(8)\nUnc: Timestamp(8)\nUnc: Varchar(255)\nUnc: Varchar(255)\nUnc: Float(8)\nUnc: Float(8)\nUnc: Varchar(255)\nUnc: Varchar(255)\nUnc: Float(8)\nUnc: Varchar(255)\nUnc: Float(8)\nUnc: Float(8)\nUnc: Float(8)\nUnc: Timestamp(8)\nUnc: Varchar(255)\nUnc: Float(8)\nUnc: Varchar(255)\nUnc: Float(8)\nUnc: Varchar(255)\nUnc: Varchar(255)\nUnc: Float(8)\nUnc: Float(8)\nUnc: Float(8)\nUnc: Integer(8)\nUnc: Float(8)\nUnc: Float(8)\nUnc: Float(8)\nUnc: Float(8)\nUnc: Float(8)\nUnc: Timestamp(8)\nUnc: Varchar(255)\nUnc: Varchar(255)\nUnc: Float(8)\nUnc: Float(8)\nUnc: Varchar(255)\nUnc: TimestampTz(8)\nUnc: Integer(8)\nUnc: Float(8)\nUnc: Varchar(255)\nUnc: Float(8)\nUnc: Float(8)\nUnc: Varchar(255)\nUnc: Varchar(255)\nUnc: Float(8)\nUnc: Varchar(255)\nUnc: Float(8)\nUnc: Float(8)\nUnc: Float(8)\nUnc: Varchar(255)\nUnc: Float(8)\nUnc: Float(8)\nUnc: Float(8)\nUnc: Float(8)\nUnc: Float(8)\nUnc: Float(8)\nUnc: Float(8)\nUnc: Float(8)\nUnc: Varchar(255)\nUnc: Varchar(255)\nUnc: Float(8)\nUnc: Boolean(1)\nUnc: Varchar(255)\nUnc: Float(8)\nUnc: Varchar(255)\nUnc: Varchar(255)\nUnc: Float(8)\nUnc: Float(8)\nUnc: Float(8)\nUnc: Float(8)\nUnc: Varchar(255)\nUnc: Varchar(255)\nUnc: Float(8)\nUnc: Timestamp(8)\nUnc: Varchar(255)\nUnc: Float(8)\nUnc: Varchar(255)\nUnc: Varchar(255)\nUnc: Float(8)\nUnc: Varchar(255)\nUnc: Timestamp(8)\nUnc: Varchar(255)\nUnc: Varchar(255)\nUnc: Float(8)\nUnc: Float(8)\nUnc: Float(8)\nUnc: Integer(8)\nUnc: Boolean(1)\nUnc: Float(8)\nUnc: Varchar(255)\nUnc: Varchar(255)\nUnc: Varchar(255)\nUnc: Float(8)\nUnc: Varchar(255)\nUnc: Float(8)\nUnc: Float(8)\nUnc: Varchar(255)\nUnc: Varchar(255)\nUnc: Float(8)\nUnc: Timestamp(8)\nUnc: Varchar(255)\nUnc: Varchar(255)\nUnc: Float(8)\nUnc: Float(8)\nUnc: Varchar(255)\nUnc: Varchar(255)\nUnc: Float(8)\nUnc: Varchar(255)\nUnc: Float(8)\nUnc: Float(8)\nUnc: Float(8)\nUnc: Timestamp(8)\nUnc: Varchar(255)\nUnc: Float(8)\nUnc: Varchar(255)\nUnc: Float(8)\nUnc: Varchar(255)\nUnc: Varchar(255)\nUnc: Float(8)\nUnc: Float(8)\nUnc: Float(8)\nUnc: Integer(8)\nUnc: Float(8)\nUnc: Float(8)\nUnc: Float(8)\nUnc: Float(8)\nUnc: Float(8)\nUnc: Timestamp(8)\nUnc: Varchar(255)\nUnc: Varchar(255)\nUnc: Float(8)\nUnc: Float(8)\nUnc: Varchar(255)\nUnc: TimestampTz(8)\nUnc: Integer(8)\nUnc: Boolean(1)"", color = ""green"", shape = ""box""];"
"3[label = ""ExprEval: \n CASE WHEN SE[0] THEN VAL(0) ELSE VAL(193) END\n CASE WHEN SE[0] THEN gametransaction.* ELSE VAL(194) END\n CASE WHEN SE[0] THEN VAL(2) ELSE VAL(195) END\n CASE WHEN SE[0] THEN VAL(3) ELSE VAL(196) END\n CASE WHEN SE[0] THEN VAL(4) ELSE VAL(197) END\n CASE WHEN SE[0] THEN VAL(5) ELSE VAL(198) END\n CASE WHEN SE[0] THEN VAL(6) ELSE VAL(199) END\n CASE WHEN SE[0] THEN VAL(7) ELSE VAL(200) END\n CASE WHEN SE[0] THEN VAL(8) ELSE VAL(201) END\n CASE WHEN SE[0] THEN VAL(9) ELSE VAL(202) END\n CASE WHEN SE[0] THEN VAL(10) ELSE VAL(203) END\n CASE WHEN SE[0] THEN VAL(11) ELSE VAL(204) END\n CASE WHEN SE[0] THEN VAL(12) ELSE VAL(205) END\n CASE WHEN SE[0] THEN VAL(13) ELSE VAL(206) END\n CASE WHEN SE[0] THEN VAL(14) ELSE VAL(207) END\n CASE WHEN SE[0] THEN VAL(15) ELSE VAL(208) END\n CASE WHEN SE[0] THEN VAL(16) ELSE VAL(209) END\n CASE WHEN SE[0] THEN VAL(17) ELSE VAL(210) END\n CASE WHEN SE[0] THEN VAL(18) ELSE VAL(211) END\n CASE WHEN SE[0] THEN VAL(19) ELSE VAL(212) END\n CASE WHEN SE[0] THEN VAL(20) ELSE VAL(213) END\n CASE WHEN SE[0] THEN VAL(21) ELSE VAL(214) END\n CASE WHEN SE[0] THEN VAL(22) ELSE VAL(215) END\n CASE WHEN SE[0] THEN VAL(23) ELSE VAL(216) END\n CASE WHEN SE[0] THEN VAL(24) ELSE VAL(217) END\n CASE WHEN SE[0] THEN VAL(25) ELSE VAL(218) END\n CASE WHEN SE[0] THEN VAL(26) ELSE VAL(219) END\n CASE WHEN SE[0] THEN VAL(27) ELSE VAL(220) END\n CASE WHEN SE[0] THEN VAL(28) ELSE VAL(221) END\n CASE WHEN SE[0] THEN VAL(29) ELSE VAL(222) END\n CASE WHEN SE[0] THEN VAL(30) ELSE VAL(223) END\n CASE WHEN SE[0] THEN VAL(31) ELSE VAL(224) END\n CASE WHEN SE[0] THEN VAL(32) ELSE VAL(225) END\n CASE WHEN SE[0] THEN VAL(33) ELSE VAL(226) END\n CASE WHEN SE[0] THEN VAL(34) ELSE VAL(227) END\n CASE WHEN SE[0] THEN VAL(35) ELSE VAL(228) END\n CASE WHEN SE[0] THEN VAL(36) ELSE VAL(229) END\n CASE WHEN SE[0] THEN VAL(37) ELSE VAL(230) END\n CASE WHEN SE[0] THEN VAL(38) ELSE VAL(231) END\n CASE WHEN SE[0] THEN VAL(39) ELSE VAL(232) END\n CASE WHEN SE[0] THEN VAL(40) ELSE VAL(233) END\n CASE WHEN SE[0] THEN VAL(41) ELSE VAL(234) END\n CASE WHEN SE[0] THEN VAL(42) ELSE VAL(235) END\n CASE WHEN SE[0] THEN VAL(43) ELSE VAL(236) END\n CASE WHEN SE[0] THEN VAL(44) ELSE VAL(237) END\n CASE WHEN SE[0] THEN VAL(45) ELSE VAL(238) END\n CASE WHEN SE[0] THEN VAL(46) ELSE VAL(239) END\n CASE WHEN SE[0] THEN VAL(47) ELSE VAL(240) END\n CASE WHEN SE[0] THEN VAL(48) ELSE VAL(241) END\n CASE WHEN SE[0] THEN VAL(49) ELSE VAL(242) END\n CASE WHEN SE[0] THEN VAL(50) ELSE VAL(243) END\n CASE WHEN SE[0] THEN VAL(51) ELSE VAL(244) END\n CASE WHEN SE[0] THEN VAL(52) ELSE VAL(245) END\n CASE WHEN SE[0] THEN VAL(53) ELSE VAL(246) END\n CASE WHEN SE[0] THEN VAL(54) ELSE VAL(247) END\n CASE WHEN SE[0] THEN VAL(55) ELSE VAL(248) END\n CASE WHEN SE[0] THEN VAL(56) ELSE VAL(249) END\n CASE WHEN SE[0] THEN VAL(57) ELSE VAL(250) END\n CASE WHEN SE[0] THEN VAL(58) ELSE VAL(251) END\n CASE WHEN SE[0] THEN VAL(59) ELSE VAL(252) END\n CASE WHEN SE[0] THEN VAL(60) ELSE VAL(253) END\n CASE WHEN SE[0] THEN VAL(61) ELSE VAL(254) END\n CASE WHEN SE[0] THEN VAL(62) ELSE VAL(255) END\n CASE WHEN SE[0] THEN VAL(63) ELSE VAL(256) END\n CASE WHEN SE[0] THEN VAL(64) ELSE VAL(257) END\n CASE WHEN SE[0] THEN VAL(65) ELSE VAL(258) END\n CASE WHEN SE[0] THEN VAL(66) ELSE VAL(259) END\n CASE WHEN SE[0] THEN VAL(67) ELSE VAL(260) END\n CASE WHEN SE[0] THEN VAL(68) ELSE VAL(261) END\n CASE WHEN SE[0] THEN VAL(69) ELSE VAL(262) END\n CASE WHEN SE[0] THEN VAL(70) ELSE VAL(263) END\n CASE WHEN SE[0] THEN VAL(71) ELSE VAL(264) END\n CASE WHEN SE[0] THEN VAL(72) ELSE VAL(265) END\n CASE WHEN SE[0] THEN VAL(73) ELSE VAL(266) END\n CASE WHEN SE[0] THEN VAL(74) ELSE VAL(267) END\n CASE WHEN SE[0] THEN VAL(75) ELSE VAL(268) END\n CASE WHEN SE[0] THEN VAL(76) ELSE VAL(269) END\n CASE WHEN SE[0] THEN VAL(77) ELSE VAL(270) END\n CASE WHEN SE[0] THEN VAL(78) ELSE VAL(271) END\n CASE WHEN SE[0] THEN VAL(79) ELSE VAL(272) END\n CASE WHEN SE[0] THEN VAL(80) ELSE VAL(273) END\n CASE WHEN SE[0] THEN VAL(81) ELSE VAL(274) END\n CASE WHEN SE[0] THEN VAL(82) ELSE VAL(275) END\n CASE WHEN SE[0] THEN VAL(83) ELSE VAL(276) END\n CASE WHEN SE[0] THEN VAL(84) ELSE VAL(277) END\n CASE WHEN SE[0] THEN VAL(85) ELSE VAL(278) END\n CASE WHEN SE[0] THEN VAL(86) ELSE VAL(279) END\n CASE WHEN SE[0] THEN VAL(87) ELSE VAL(280) END\n CASE WHEN SE[0] THEN VAL(88) ELSE VAL(281) END\n CASE WHEN SE[0] THEN VAL(89) ELSE VAL(282) END\n CASE WHEN SE[0] THEN VAL(90) ELSE VAL(283) END\n CASE WHEN SE[0] THEN VAL(91) ELSE VAL(284) END\n CASE WHEN SE[0] THEN VAL(92) ELSE VAL(285) END\n CASE WHEN SE[0] THEN VAL(93) ELSE VAL(286) END\n CASE WHEN SE[0] THEN VAL(94) ELSE VAL(287) END\n CASE WHEN SE[0] THEN VAL(95) ELSE VAL(288) END\n CASE WHEN SE[0] THEN VAL(96) ELSE VAL(96) END\n CASE WHEN SE[0] THEN VAL(97) ELSE VAL(97) END\n CASE WHEN SE[0] THEN VAL(98) ELSE VAL(98) END\n CASE WHEN SE[0] THEN VAL(99) ELSE VAL(99) END\n CASE WHEN SE[0] THEN VAL(100) ELSE VAL(100) END\n CASE WHEN SE[0] THEN VAL(101) ELSE VAL(101) END\n CASE WHEN SE[0] THEN VAL(102) ELSE VAL(102) END\n CASE WHEN SE[0] THEN VAL(103) ELSE VAL(103) END\n CASE WHEN SE[0] THEN VAL(104) ELSE VAL(104) END\n CASE WHEN SE[0] THEN VAL(105) ELSE VAL(105) END\n CASE WHEN SE[0] THEN VAL(106) ELSE VAL(106) END\n CASE WHEN SE[0] THEN VAL(107) ELSE VAL(107) END\n CASE WHEN SE[0] THEN VAL(108) ELSE VAL(108) END\n CASE WHEN SE[0] THEN VAL(109) ELSE VAL(109) END\n CASE WHEN SE[0] THEN VAL(110) ELSE VAL(110) END\n CASE WHEN SE[0] THEN VAL(111) ELSE VAL(111) END\n CASE WHEN SE[0] THEN VAL(112) ELSE VAL(112) END\n CASE WHEN SE[0] THEN VAL(113) ELSE VAL(113) END\n CASE WHEN SE[0] THEN VAL(114) ELSE VAL(114) END\n CASE WHEN SE[0] THEN VAL(115) ELSE VAL(115) END\n CASE WHEN SE[0] THEN VAL(116) ELSE VAL(116) END\n CASE WHEN SE[0] THEN VAL(117) ELSE VAL(117) END\n CASE WHEN SE[0] THEN VAL(118) ELSE VAL(118) END\n CASE WHEN SE[0] THEN VAL(119) ELSE VAL(119) END\n CASE WHEN SE[0] THEN VAL(120) ELSE VAL(120) END\n CASE WHEN SE[0] THEN VAL(121) ELSE VAL(121) END\n CASE WHEN SE[0] THEN VAL(122) ELSE VAL(122) END\n CASE WHEN SE[0] THEN VAL(123) ELSE VAL(123) END\n CASE WHEN SE[0] THEN VAL(124) ELSE VAL(124) END\n CASE WHEN SE[0] THEN VAL(125) ELSE VAL(125) END\n CASE WHEN SE[0] THEN VAL(126) ELSE VAL(126) END\n CASE WHEN SE[0] THEN VAL(127) ELSE VAL(127) END\n CASE WHEN SE[0] THEN VAL(128) ELSE VAL(128) END\n CASE WHEN SE[0] THEN VAL(129) ELSE VAL(129) END\n CASE WHEN SE[0] THEN VAL(130) ELSE VAL(130) END\n CASE WHEN SE[0] THEN VAL(131) ELSE VAL(131) END\n CASE WHEN SE[0] THEN VAL(132) ELSE VAL(132) END\n CASE WHEN SE[0] THEN VAL(133) ELSE VAL(133) END\n CASE WHEN SE[0] THEN VAL(134) ELSE VAL(134) END\n CASE WHEN SE[0] THEN VAL(135) ELSE VAL(135) END\n CASE WHEN SE[0] THEN VAL(136) ELSE VAL(136) END\n CASE WHEN SE[0] THEN VAL(137) ELSE VAL(137) END\n CASE WHEN SE[0] THEN VAL(138) ELSE VAL(138) END\n CASE WHEN SE[0] THEN VAL(139) ELSE VAL(139) END\n CASE WHEN SE[0] THEN VAL(140) ELSE VAL(140) END\n CASE WHEN SE[0] THEN VAL(141) ELSE VAL(141) END\n CASE WHEN SE[0] THEN VAL(142) ELSE VAL(142) END\n CASE WHEN SE[0] THEN VAL(143) ELSE VAL(143) END\n CASE WHEN SE[0] THEN VAL(144) ELSE VAL(144) END\n CASE WHEN SE[0] THEN VAL(145) ELSE VAL(145) END\n CASE WHEN SE[0] THEN VAL(146) ELSE VAL(146) END\n CASE WHEN SE[0] THEN VAL(147) ELSE VAL(147) END\n CASE WHEN SE[0] THEN VAL(148) ELSE VAL(148) END\n CASE WHEN SE[0] THEN VAL(149) ELSE VAL(149) END\n CASE WHEN SE[0] THEN VAL(150) ELSE VAL(150) END\n CASE WHEN SE[0] THEN VAL(151) ELSE VAL(151) END\n CASE WHEN SE[0] THEN VAL(152) ELSE VAL(152) END\n CASE WHEN SE[0] THEN VAL(153) ELSE VAL(153) END\n CASE WHEN SE[0] THEN VAL(154) ELSE VAL(154) END\n CASE WHEN SE[0] THEN VAL(155) ELSE VAL(155) END\n CASE WHEN SE[0] THEN VAL(156) ELSE VAL(156) END\n CASE WHEN SE[0] THEN VAL(157) ELSE VAL(157) END\n CASE WHEN SE[0] THEN VAL(158) ELSE VAL(158) END\n CASE WHEN SE[0] THEN VAL(159) ELSE VAL(159) END\n CASE WHEN SE[0] THEN VAL(160) ELSE VAL(160) END\n CASE WHEN SE[0] THEN VAL(161) ELSE VAL(161) END\n CASE WHEN SE[0] THEN VAL(162) ELSE VAL(162) END\n CASE WHEN SE[0] THEN VAL(163) ELSE VAL(163) END\n CASE WHEN SE[0] THEN VAL(164) ELSE VAL(164) END\n CASE WHEN SE[0] THEN VAL(165) ELSE VAL(165) END\n CASE WHEN SE[0] THEN VAL(166) ELSE VAL(166) END\n CASE WHEN SE[0] THEN VAL(167) ELSE VAL(167) END\n CASE WHEN SE[0] THEN VAL(168) ELSE VAL(168) END\n CASE WHEN SE[0] THEN VAL(169) ELSE VAL(169) END\n CASE WHEN SE[0] THEN VAL(170) ELSE VAL(170) END\n CASE WHEN SE[0] THEN VAL(171) ELSE VAL(171) END\n CASE WHEN SE[0] THEN VAL(172) ELSE VAL(172) END\n CASE WHEN SE[0] THEN VAL(173) ELSE VAL(173) END\n CASE WHEN SE[0] THEN VAL(174) ELSE VAL(174) END\n CASE WHEN SE[0] THEN VAL(175) ELSE VAL(175) END\n CASE WHEN SE[0] THEN VAL(176) ELSE VAL(176) END\n CASE WHEN SE[0] THEN VAL(177) ELSE VAL(177) END\n CASE WHEN SE[0] THEN VAL(178) ELSE VAL(178) END\n CASE WHEN SE[0] THEN VAL(179) ELSE VAL(179) END\n CASE WHEN SE[0] THEN VAL(180) ELSE VAL(180) END\n CASE WHEN SE[0] THEN VAL(181) ELSE VAL(181) END\n CASE WHEN SE[0] THEN VAL(182) ELSE VAL(182) END\n CASE WHEN SE[0] THEN VAL(183) ELSE VAL(183) END\n CASE WHEN SE[0] THEN VAL(184) ELSE VAL(184) END\n CASE WHEN SE[0] THEN VAL(185) ELSE VAL(185) END\n CASE WHEN SE[0] THEN VAL(186) ELSE VAL(186) END\n CASE WHEN SE[0] THEN VAL(187) ELSE VAL(187) END\n CASE WHEN SE[0] THEN VAL(188) ELSE VAL(188) END\n CASE WHEN SE[0] THEN VAL(189) ELSE VAL(189) END\n CASE WHEN SE[0] THEN VAL(190) ELSE VAL(190) END\n CASE WHEN SE[0] THEN VAL(191) ELSE VAL(191) END\n CASE WHEN SE[0] THEN VAL(192) ELSE VAL(192) END\n SE[0] = (VAL(192) = true): 193 uses\nUnc: Float(8)\nUnc: Varchar(255)\nUnc: Float(8)\nUnc: Float(8)\nUnc: Varchar(255)\nUnc: Varchar(255)\nUnc: Float(8)\nUnc: Varchar(255)\nUnc: Float(8)\nUnc: Float(8)\nUnc: Float(8)\nUnc: Varchar(255)\nUnc: Float(8)\nUnc: Float(8)\nUnc: Float(8)\nUnc: Float(8)\nUnc: Float(8)\nUnc: Float(8)\nUnc: Float(8)\nUnc: Float(8)\nUnc: Varchar(255)\nUnc: Varchar(255)\nUnc: Float(8)\nUnc: Boolean(1)\nUnc: Varchar(255)\nUnc: Float(8)\nUnc: Varchar(255)\nUnc: Varchar(255)\nUnc: Float(8)\nUnc: Float(8)\nUnc: Float(8)\nUnc: Float(8)\nUnc: Varchar(255)\nUnc: Varchar(255)\nUnc: Float(8)\nUnc: Timestamp(8)\nUnc: Varchar(255)\nUnc: Float(8)\nUnc: Varchar(255)\nUnc: Varchar(255)\nUnc: Float(8)\nUnc: Varchar(255)\nUnc: Timestamp(8)\nUnc: Varchar(255)\nUnc: Varchar(255)\nUnc: Float(8)\nUnc: Float(8)\nUnc: Float(8)\nUnc: Integer(8)\nUnc: Boolean(1)\nUnc: Float(8)\nUnc: Varchar(255)\nUnc: Varchar(255)\nUnc: Varchar(255)\nUnc: Float(8)\nUnc: Varchar(255)\nUnc: Float(8)\nUnc: Float(8)\nUnc: Varchar(255)\nUnc: Varchar(255)\nUnc: Float(8)\nUnc: Timestamp(8)\nUnc: Varchar(255)\nUnc: Varchar(255)\nUnc: Float(8)\nUnc: Float(8)\nUnc: Varchar(255)\nUnc: Varchar(255)\nUnc: Float(8)\nUnc: Varchar(255)\nUnc: Float(8)\nUnc: Float(8)\nUnc: Float(8)\nUnc: Timestamp(8)\nUnc: Varchar(255)\nUnc: Float(8)\nUnc: Varchar(255)\nUnc: Float(8)\nUnc: Varchar(255)\nUnc: Varchar(255)\nUnc: Float(8)\nUnc: Float(8)\nUnc: Float(8)\nUnc: Integer(8)\nUnc: Float(8)\nUnc: Float(8)\nUnc: Float(8)\nUnc: Float(8)\nUnc: Float(8)\nUnc: Timestamp(8)\nUnc: Varchar(255)\nUnc: Varchar(255)\nUnc: Float(8)\nUnc: Float(8)\nUnc: Varchar(255)\nUnc: TimestampTz(8)\nUnc: Integer(8)\nUnc: Varchar(81)\nUnc: Varchar(81)\nUnc: Float(8)\nUnc: Float(8)\nUnc: Varchar(81)\nUnc: Varchar(81)\nUnc: Varchar(81)\nUnc: Float(8)\nUnc: Boolean(1)\nUnc: Float(8)\nUnc: Varchar(81)\nUnc: Float(8)\nUnc: Float(8)\nUnc: Timestamp(8)\nUnc: Float(8)\nUnc: Varchar(81)\nUnc: Float(8)\nUnc: Float(8)\nUnc: Float(8)\nUnc: Float(8)\nUnc: Float(8)\nUnc: Float(8)\nUnc: Varchar(81)\nUnc: Float(8)\nUnc: Float(8)\nUnc: Boolean(1)\nUnc: Varchar(81)\nUnc: Float(8)\nUnc: Float(8)\nUnc: Float(8)\nUnc: Timestamp(8)\nUnc: Float(8)\nUnc: Float(8)\nUnc: Varchar(81)\nUnc: Varchar(81)\nUnc: Float(8)\nUnc: Float(8)\nUnc: Float(8)\nUnc: Varchar(81)\nUnc: Float(8)\nUnc: Float(8)\nUnc: Varchar(81)\nUnc: Varchar(81)\nUnc: Varchar(81)\nUnc: Float(8)\nUnc: Varchar(81)\nUnc: Varchar(81)\nUnc: Float(8)\nUnc: Varchar(81)\nUnc: Float(8)\nUnc: Float(8)\nUnc: Timestamp(8)\nUnc: Varchar(81)\nUnc: Varchar(81)\nUnc: Varchar(81)\nUnc: Float(8)\nUnc: Varchar(81)\nUnc: Float(8)\nUnc: Varchar(81)\nUnc: Float(8)\nUnc: Varchar(81)\nUnc: Float(8)\nUnc: Float(8)\nUnc: Varchar(81)\nUnc: Float(8)\nUnc: Float(8)\nUnc: Varchar(81)\nUnc: Timestamp(8)\nUnc: Varchar(81)\nUnc: Varchar(81)\nUnc: Float(8)\nUnc: Float(8)\nUnc: Varchar(81)\nUnc: Integer(8)\nUnc: Float(8)\nUnc: Float(8)\nUnc: Varchar(81)\nUnc: Float(8)\nUnc: Float(8)\nUnc: Timestamp(8)\nUnc: Float(8)\nUnc: Integer(8)\nUnc: Varchar(81)\nUnc: Float(8)\nUnc: Varchar(81)\nUnc: Float(8)\nUnc: Varchar(81)\nUnc: Varchar(81)\nUnc: Float(8)\nUnc: Float(8)\nUnc: Float(8)\nUnc: Float(8)\nUnc: Varchar(81)\nUnc: Varchar(81)\nUnc: Float(8)\nUnc: Boolean(1)"", color = ""green"", shape = ""box""];"
"4[label = ""ExprEval: \n gametransaction.amountReal_eur\n gametransaction.gameTransactionId\n gametransaction.jackpotAmount_base\n gametransaction.walletAmount\n gametransaction.betslipId\n gametransaction.reason\n gametransaction.jackpotContribution_base\n gametransaction.providerSportsbookId\n gametransaction.balanceAfter_eur\n gametransaction.fxSpread\n gametransaction.jackpotAmount\n gametransaction.sportsbook\n gametransaction.providerAmount\n gametransaction.amount_eur\n gametransaction.availableBalanceAfter_base\n gametransaction.availableBalanceAfterBonus_eur\n gametransaction.availableBalanceAfterReal_base\n gametransaction.availableBalanceAfterBonus_base\n gametransaction.balanceAfterBonus_base\n gametransaction.amountBonus\n gametransaction.details\n gametransaction.providerGameTransactionId\n gametransaction.walletAmount_eur\n gametransaction.discardable\n gametransaction._CELONIS_INPUT_FILE\n gametransaction.jackpotContribution\n gametransaction.terminalRef\n gametransaction.shopRef\n gametransaction.sportsbookWinnings_base\n gametransaction.fxRate\n gametransaction.availableBalanceAfter_eur\n gametransaction.balanceAfter_base\n gametransaction.sessionId\n gametransaction.status\n gametransaction.sportsbookWinnings_eur\n gametransaction.betslipSettledAt\n gametransaction.sportsbookStatus\n gametransaction.balanceAfter\n gametransaction.transactionReason\n gametransaction.betslip\n gametransaction.taxAmount\n gametransaction.device\n gametransaction.succeededAt\n gametransaction.promotionId\n gametransaction.sportsbookId\n gametransaction.taxAmount_eur\n gametransaction.taxAmount_base\n gametransaction.availableBalanceAfterBonus\n gametransaction.version\n gametransaction.promotional\n gametransaction.balanceAfterBonus\n gametransaction.gameTransactionType\n gametransaction.providerGameSessionId\n gametransaction.currencyCode\n gametransaction.amount\n gametransaction.userId\n gametransaction.providerAmount_eur\n gametransaction.jackpotContribution_eur\n gametransaction.errorCode\n gametransaction.message\n gametransaction.walletAmount_base\n gametransaction.processedAt\n gametransaction.provider\n gametransaction.syndicateSessionId\n gametransaction.betslipWinnings_eur\n gametransaction.availableBalanceAfterReal\n gametransaction.gameRoundId\n gametransaction.betslipStatus\n gametransaction.balanceAfterReal\n gametransaction.studio\n gametransaction.availableBalanceAfterReal_eur\n gametransaction.amountReal_base\n gametransaction.betslipWinnings_base\n gametransaction.updatedAt\n gametransaction.gameSessionId\n gametransaction.amountBonus_base\n gametransaction.code\n gametransaction.providerAmount_base\n gametransaction.providerRoundId\n gametransaction.providerBetslipId\n gametransaction.amount_base\n gametransaction.balanceAfterReal_base\n gametransaction.availableBalanceAfter\n gametransaction.gameRoundIndex\n gametransaction.balanceAfterReal_eur\n gametransaction.jackpotAmount_eur\n gametransaction.amountReal\n gametransaction.betslipWinnings\n gametransaction.sportsbookWinnings\n gametransaction.createdAt\n gametransaction.amounts\n gametransaction.gameId\n gametransaction.balanceAfterBonus_eur\n gametransaction.amountBonus_eur\n gametransaction.walletCurrencyCode\n gametransaction._CELONIS_CHANGE_DATE\n gametransaction.epoch\n VAL(2)\n VAL(2)\n VAL(2)\n VAL(2)\n VAL(2)\n VAL(2)\n VAL(2)\n VAL(2)\n VAL(2)\n VAL(2)\n VAL(2)\n VAL(2)\n VAL(2)\n VAL(2)\n VAL(2)\n VAL(2)\n VAL(2)\n VAL(2)\n VAL(2)\n VAL(2)\n VAL(2)\n VAL(2)\n VAL(2)\n VAL(2)\n VAL(2)\n VAL(2)\n VAL(2)\n VAL(2)\n VAL(2)\n VAL(2)\n VAL(2)\n VAL(2)\n VAL(2)\n VAL(2)\n VAL(2)\n VAL(2)\n VAL(2)\n VAL(2)\n VAL(2)\n VAL(2)\n VAL(2)\n VAL(2)\n VAL(2)\n VAL(2)\n VAL(2)\n VAL(2)\n VAL(2)\n VAL(2)\n VAL(2)\n VAL(2)\n VAL(2)\n VAL(2)\n VAL(2)\n VAL(2)\n VAL(2)\n VAL(2)\n VAL(2)\n VAL(2)\n VAL(2)\n VAL(2)\n VAL(2)\n VAL(2)\n VAL(2)\n VAL(2)\n VAL(2)\n VAL(2)\n VAL(2)\n VAL(2)\n VAL(2)\n VAL(2)\n VAL(2)\n VAL(2)\n VAL(2)\n VAL(2)\n VAL(2)\n VAL(2)\n VAL(2)\n VAL(2)\n VAL(2)\n VAL(2)\n VAL(2)\n VAL(2)\n VAL(2)\n VAL(2)\n VAL(2)\n VAL(2)\n VAL(2)\n VAL(2)\n VAL(2)\n VAL(2)\n VAL(2)\n VAL(2)\n VAL(2)\n VAL(2)\n VAL(2)\n VAL(2)\n VAL(2)\n VAL(2)\n VAL(2)\n VAL(2)\n VAL(2)\n VAL(2)\n VAL(2)\n VAL(2)\n VAL(2)\n VAL(2)\n VAL(2)\n VAL(2)\n VAL(2)\n VAL(2)\n VAL(2)\n VAL(2)\n VAL(2)\n VAL(2)\n VAL(2)\n VAL(2)\n VAL(2)\n VAL(2)\n VAL(2)\n VAL(2)\n VAL(2)\n VAL(2)\n VAL(2)\n VAL(2)\n VAL(2)\n VAL(2)\n VAL(2)\n VAL(2)\n VAL(2)\n VAL(2)\n VAL(2)\n VAL(2)\n VAL(2)\n VAL(2)\n VAL(2)\n VAL(2)\n VAL(2)\n VAL(2)\n VAL(2)\n VAL(2)\n VAL(2)\n VAL(2)\n VAL(2)\n VAL(2)\n VAL(2)\n VAL(2)\n VAL(2)\n VAL(2)\n VAL(2)\n VAL(2)\n VAL(2)\n VAL(2)\n VAL(2)\n VAL(2)\n VAL(2)\n VAL(2)\n VAL(2)\n VAL(2)\n VAL(2)\n VAL(2)\n VAL(2)\n VAL(2)\n VAL(2)\n VAL(2)\n VAL(2)\n VAL(2)\n VAL(2)\n VAL(2)\n VAL(2)\n VAL(2)\n VAL(2)\n VAL(2)\n VAL(2)\n VAL(2)\n VAL(2)\n VAL(2)\n VAL(2)\n VAL(2)\n VAL(2)\n VAL(2)\n VAL(2)\n VAL(2)\n VAL(2)\n VAL(2)\n VAL(2)\n VAL(2)\n VAL(2)\n VAL(2)\n VAL(2)\n VAL(2)\n VAL(2)\n (now())::timestamptz(3)\nUnc: Float(8)\nUnc: Varchar(255)\nUnc: Float(8)\nUnc: Float(8)\nUnc: Varchar(255)\nUnc: Varchar(255)\nUnc: Float(8)\nUnc: Varchar(255)\nUnc: Float(8)\nUnc: Float(8)\nUnc: Float(8)\nUnc: Varchar(255)\nUnc: Float(8)\nUnc: Float(8)\nUnc: Float(8)\nUnc: Float(8)\nUnc: Float(8)\nUnc: Float(8)\nUnc: Float(8)\nUnc: Float(8)\nUnc: Varchar(255)\nUnc: Varchar(255)\nUnc: Float(8)\nUnc: Boolean(1)\nUnc: Varchar(255)\nUnc: Float(8)\nUnc: Varchar(255)\nUnc: Varchar(255)\nUnc: Float(8)\nUnc: Float(8)\nUnc: Float(8)\nUnc: Float(8)\nUnc: Varchar(255)\nUnc: Varchar(255)\nUnc: Float(8)\nUnc: Timestamp(8)\nUnc: Varchar(255)\nUnc: Float(8)\nUnc: Varchar(255)\nUnc: Varchar(255)\nUnc: Float(8)\nUnc: Varchar(255)\nUnc: Timestamp(8)\nUnc: Varchar(255)\nUnc: Varchar(255)\nUnc: Float(8)\nUnc: Float(8)\nUnc: Float(8)\nUnc: Integer(8)\nUnc: Boolean(1)\nUnc: Float(8)\nUnc: Varchar(255)\nUnc: Varchar(255)\nUnc: Varchar(255)\nUnc: Float(8)\nUnc: Varchar(255)\nUnc: Float(8)\nUnc: Float(8)\nUnc: Varchar(255)\nUnc: Varchar(255)\nUnc: Float(8)\nUnc: Timestamp(8)\nUnc: Varchar(255)\nUnc: Varchar(255)\nUnc: Float(8)\nUnc: Float(8)\nUnc: Varchar(255)\nUnc: Varchar(255)\nUnc: Float(8)\nUnc: Varchar(255)\nUnc: Float(8)\nUnc: Float(8)\nUnc: Float(8)\nUnc: Timestamp(8)\nUnc: Varchar(255)\nUnc: Float(8)\nUnc: Varchar(255)\nUnc: Float(8)\nUnc: Varchar(255)\nUnc: Varchar(255)\nUnc: Float(8)\nUnc: Float(8)\nUnc: Float(8)\nUnc: Integer(8)\nUnc: Float(8)\nUnc: Float(8)\nUnc: Float(8)\nUnc: Float(8)\nUnc: Float(8)\nUnc: Timestamp(8)\nUnc: Varchar(255)\nUnc: Varchar(255)\nUnc: Float(8)\nUnc: Float(8)\nUnc: Varchar(255)\nUnc: TimestampTz(8)\nUnc: Integer(8)\nUnc: Varchar(81)\nUnc: Varchar(81)\nUnc: Float(8)\nUnc: Float(8)\nUnc: Varchar(81)\nUnc: Varchar(81)\nUnc: Varchar(81)\nUnc: Float(8)\nUnc: Boolean(1)\nUnc: Float(8)\nUnc: Varchar(81)\nUnc: Float(8)\nUnc: Float(8)\nUnc: Timestamp(8)\nUnc: Float(8)\nUnc: Varchar(81)\nUnc: Float(8)\nUnc: Float(8)\nUnc: Float(8)\nUnc: Float(8)\nUnc: Float(8)\nUnc: Float(8)\nUnc: Varchar(81)\nUnc: Float(8)\nUnc: Float(8)\nUnc: Boolean(1)\nUnc: Varchar(81)\nUnc: Float(8)\nUnc: Float(8)\nUnc: Float(8)\nUnc: Timestamp(8)\nUnc: Float(8)\nUnc: Float(8)\nUnc: Varchar(81)\nUnc: Varchar(81)\nUnc: Float(8)\nUnc: Float(8)\nUnc: Float(8)\nUnc: Varchar(81)\nUnc: Float(8)\nUnc: Float(8)\nUnc: Varchar(81)\nUnc: Varchar(81)\nUnc: Varchar(81)\nUnc: Float(8)\nUnc: Varchar(81)\nUnc: Varchar(81)\nUnc: Float(8)\nUnc: Varchar(81)\nUnc: Float(8)\nUnc: Float(8)\nUnc: Timestamp(8)\nUnc: Varchar(81)\nUnc: Varchar(81)\nUnc: Varchar(81)\nUnc: Float(8)\nUnc: Varchar(81)\nUnc: Float(8)\nUnc: Varchar(81)\nUnc: Float(8)\nUnc: Varchar(81)\nUnc: Float(8)\nUnc: Float(8)\nUnc: Varchar(81)\nUnc: Float(8)\nUnc: Float(8)\nUnc: Varchar(81)\nUnc: Timestamp(8)\nUnc: Varchar(81)\nUnc: Varchar(81)\nUnc: Float(8)\nUnc: Float(8)\nUnc: Varchar(81)\nUnc: Integer(8)\nUnc: Float(8)\nUnc: Float(8)\nUnc: Varchar(81)\nUnc: Float(8)\nUnc: Float(8)\nUnc: Timestamp(8)\nUnc: Float(8)\nUnc: Integer(8)\nUnc: Varchar(81)\nUnc: Float(8)\nUnc: Varchar(81)\nUnc: Float(8)\nUnc: Varchar(81)\nUnc: Varchar(81)\nUnc: Float(8)\nUnc: Float(8)\nUnc: Float(8)\nUnc: Float(8)\nUnc: Varchar(81)\nUnc: Varchar(81)\nUnc: Float(8)\nUnc: Boolean(1)\nUnc: Float(8)\nUnc: Varchar(255)\nUnc: Float(8)\nUnc: Float(8)\nUnc: Varchar(255)\nUnc: Varchar(255)\nUnc: Float(8)\nUnc: Varchar(255)\nUnc: Float(8)\nUnc: Float(8)\nUnc: Float(8)\nUnc: Varchar(255)\nUnc: Float(8)\nUnc: Float(8)\nUnc: Float(8)\nUnc: Float(8)\nUnc: Float(8)\nUnc: Float(8)\nUnc: Float(8)\nUnc: Float(8)\nUnc: Varchar(255)\nUnc: Varchar(255)\nUnc: Float(8)\nUnc: Boolean(1)\nUnc: Varchar(255)\nUnc: Float(8)\nUnc: Varchar(255)\nUnc: Varchar(255)\nUnc: Float(8)\nUnc: Float(8)\nUnc: Float(8)\nUnc: Float(8)\nUnc: Varchar(255)\nUnc: Varchar(255)\nUnc: Float(8)\nUnc: Timestamp(8)\nUnc: Varchar(255)\nUnc: Float(8)\nUnc: Varchar(255)\nUnc: Varchar(255)\nUnc: Float(8)\nUnc: Varchar(255)\nUnc: Timestamp(8)\nUnc: Varchar(255)\nUnc: Varchar(255)\nUnc: Float(8)\nUnc: Float(8)\nUnc: Float(8)\nUnc: Integer(8)\nUnc: Boolean(1)\nUnc: Float(8)\nUnc: Varchar(255)\nUnc: Varchar(255)\nUnc: Varchar(255)\nUnc: Float(8)\nUnc: Varchar(255)\nUnc: Float(8)\nUnc: Float(8)\nUnc: Varchar(255)\nUnc: Varchar(255)\nUnc: Float(8)\nUnc: Timestamp(8)\nUnc: Varchar(255)\nUnc: Varchar(255)\nUnc: Float(8)\nUnc: Float(8)\nUnc: Varchar(255)\nUnc: Varchar(255)\nUnc: Float(8)\nUnc: Varchar(255)\nUnc: Float(8)\nUnc: Float(8)\nUnc: Float(8)\nUnc: Timestamp(8)\nUnc: Varchar(255)\nUnc: Float(8)\nUnc: Varchar(255)\nUnc: Float(8)\nUnc: Varchar(255)\nUnc: Varchar(255)\nUnc: Float(8)\nUnc: Float(8)\nUnc: Float(8)\nUnc: Integer(8)\nUnc: Float(8)\nUnc: Float(8)\nUnc: Float(8)\nUnc: Float(8)\nUnc: Float(8)\nUnc: Timestamp(8)\nUnc: Varchar(255)\nUnc: Varchar(255)\nUnc: Float(8)\nUnc: Float(8)\nUnc: Varchar(255)\nUnc: TimestampTz(8)"", color = ""green"", shape = ""box""];"
"5[label = ""Join: Hash-Join: \n(public.gametransaction x v_temp_schema._CELONIS_TMP_gametransaction) using gametransaction_super and subquery (PATH ID: 1)\n[RightOuter]\n\nUnc: Float(8)\nUnc: Varchar(255)\nUnc: Float(8)\nUnc: Float(8)\nUnc: Varchar(255)\nUnc: Varchar(255)\nUnc: Float(8)\nUnc: Varchar(255)\nUnc: Float(8)\nUnc: Float(8)\nUnc: Float(8)\nUnc: Varchar(255)\nUnc: Float(8)\nUnc: Float(8)\nUnc: Float(8)\nUnc: Float(8)\nUnc: Float(8)\nUnc: Float(8)\nUnc: Float(8)\nUnc: Float(8)\nUnc: Varchar(255)\nUnc: Varchar(255)\nUnc: Float(8)\nUnc: Boolean(1)\nUnc: Varchar(255)\nUnc: Float(8)\nUnc: Varchar(255)\nUnc: Varchar(255)\nUnc: Float(8)\nUnc: Float(8)\nUnc: Float(8)\nUnc: Float(8)\nUnc: Varchar(255)\nUnc: Varchar(255)\nUnc: Float(8)\nUnc: Timestamp(8)\nUnc: Varchar(255)\nUnc: Float(8)\nUnc: Varchar(255)\nUnc: Varchar(255)\nUnc: Float(8)\nUnc: Varchar(255)\nUnc: Timestamp(8)\nUnc: Varchar(255)\nUnc: Varchar(255)\nUnc: Float(8)\nUnc: Float(8)\nUnc: Float(8)\nUnc: Integer(8)\nUnc: Boolean(1)\nUnc: Float(8)\nUnc: Varchar(255)\nUnc: Varchar(255)\nUnc: Varchar(255)\nUnc: Float(8)\nUnc: Varchar(255)\nUnc: Float(8)\nUnc: Float(8)\nUnc: Varchar(255)\nUnc: Varchar(255)\nUnc: Float(8)\nUnc: Timestamp(8)\nUnc: Varchar(255)\nUnc: Varchar(255)\nUnc: Float(8)\nUnc: Float(8)\nUnc: Varchar(255)\nUnc: Varchar(255)\nUnc: Float(8)\nUnc: Varchar(255)\nUnc: Float(8)\nUnc: Float(8)\nUnc: Float(8)\nUnc: Timestamp(8)\nUnc: Varchar(255)\nUnc: Float(8)\nUnc: Varchar(255)\nUnc: Float(8)\nUnc: Varchar(255)\nUnc: Varchar(255)\nUnc: Float(8)\nUnc: Float(8)\nUnc: Float(8)\nUnc: Integer(8)\nUnc: Float(8)\nUnc: Float(8)\nUnc: Float(8)\nUnc: Float(8)\nUnc: Float(8)\nUnc: Timestamp(8)\nUnc: Varchar(255)\nUnc: Varchar(255)\nUnc: Float(8)\nUnc: Float(8)\nUnc: Varchar(255)\nUnc: TimestampTz(8)\nUnc: Integer(8)\nUnc: Varchar(81)\nUnc: Varchar(81)\nUnc: Float(8)\nUnc: Float(8)\nUnc: Varchar(81)\nUnc: Varchar(81)\nUnc: Varchar(81)\nUnc: Float(8)\nUnc: Boolean(1)\nUnc: Float(8)\nUnc: Varchar(81)\nUnc: Float(8)\nUnc: Float(8)\nUnc: Timestamp(8)\nUnc: Float(8)\nUnc: Varchar(81)\nUnc: Float(8)\nUnc: Float(8)\nUnc: Float(8)\nUnc: Float(8)\nUnc: Float(8)\nUnc: Float(8)\nUnc: Varchar(81)\nUnc: Float(8)\nUnc: Float(8)\nUnc: Boolean(1)\nUnc: Varchar(81)\nUnc: Float(8)\nUnc: Float(8)\nUnc: Float(8)\nUnc: Timestamp(8)\nUnc: Float(8)\nUnc: Float(8)\nUnc: Varchar(81)\nUnc: Varchar(81)\nUnc: Float(8)\nUnc: Float(8)\nUnc: Float(8)\nUnc: Varchar(81)\nUnc: Float(8)\nUnc: Float(8)\nUnc: Varchar(81)\nUnc: Varchar(81)\nUnc: Varchar(81)\nUnc: Float(8)\nUnc: Varchar(81)\nUnc: Varchar(81)\nUnc: Float(8)\nUnc: Varchar(81)\nUnc: Float(8)\nUnc: Float(8)\nUnc: Timestamp(8)\nUnc: Varchar(81)\nUnc: Varchar(81)\nUnc: Varchar(81)\nUnc: Float(8)\nUnc: Varchar(81)\nUnc: Float(8)\nUnc: Varchar(81)\nUnc: Float(8)\nUnc: Varchar(81)\nUnc: Float(8)\nUnc: Float(8)\nUnc: Varchar(81)\nUnc: Float(8)\nUnc: Float(8)\nUnc: Varchar(81)\nUnc: Timestamp(8)\nUnc: Varchar(81)\nUnc: Varchar(81)\nUnc: Float(8)\nUnc: Float(8)\nUnc: Varchar(81)\nUnc: Integer(8)\nUnc: Float(8)\nUnc: Float(8)\nUnc: Varchar(81)\nUnc: Float(8)\nUnc: Float(8)\nUnc: Timestamp(8)\nUnc: Float(8)\nUnc: Integer(8)\nUnc: Varchar(81)\nUnc: Float(8)\nUnc: Varchar(81)\nUnc: Float(8)\nUnc: Varchar(81)\nUnc: Varchar(81)\nUnc: Float(8)\nUnc: Float(8)\nUnc: Float(8)\nUnc: Float(8)\nUnc: Varchar(81)\nUnc: Varchar(81)\nUnc: Float(8)\nUnc: Boolean(1)"", color = ""green"", shape = ""box""];"
"6[label = ""StorageUnionStep: gametransaction_super\nUnc: Float(8)\nUnc: Varchar(255)\nUnc: Float(8)\nUnc: Float(8)\nUnc: Varchar(255)\nUnc: Varchar(255)\nUnc: Float(8)\nUnc: Varchar(255)\nUnc: Float(8)\nUnc: Float(8)\nUnc: Float(8)\nUnc: Varchar(255)\nUnc: Float(8)\nUnc: Float(8)\nUnc: Float(8)\nUnc: Float(8)\nUnc: Float(8)\nUnc: Float(8)\nUnc: Float(8)\nUnc: Float(8)\nUnc: Varchar(255)\nUnc: Varchar(255)\nUnc: Float(8)\nUnc: Boolean(1)\nUnc: Varchar(255)\nUnc: Float(8)\nUnc: Varchar(255)\nUnc: Varchar(255)\nUnc: Float(8)\nUnc: Float(8)\nUnc: Float(8)\nUnc: Float(8)\nUnc: Varchar(255)\nUnc: Varchar(255)\nUnc: Float(8)\nUnc: Timestamp(8)\nUnc: Varchar(255)\nUnc: Float(8)\nUnc: Varchar(255)\nUnc: Varchar(255)\nUnc: Float(8)\nUnc: Varchar(255)\nUnc: Timestamp(8)\nUnc: Varchar(255)\nUnc: Varchar(255)\nUnc: Float(8)\nUnc: Float(8)\nUnc: Float(8)\nUnc: Integer(8)\nUnc: Boolean(1)\nUnc: Float(8)\nUnc: Varchar(255)\nUnc: Varchar(255)\nUnc: Varchar(255)\nUnc: Float(8)\nUnc: Varchar(255)\nUnc: Float(8)\nUnc: Float(8)\nUnc: Varchar(255)\nUnc: Varchar(255)\nUnc: Float(8)\nUnc: Timestamp(8)\nUnc: Varchar(255)\nUnc: Varchar(255)\nUnc: Float(8)\nUnc: Float(8)\nUnc: Varchar(255)\nUnc: Varchar(255)\nUnc: Float(8)\nUnc: Varchar(255)\nUnc: Float(8)\nUnc: Float(8)\nUnc: Float(8)\nUnc: Timestamp(8)\nUnc: Varchar(255)\nUnc: Float(8)\nUnc: Varchar(255)\nUnc: Float(8)\nUnc: Varchar(255)\nUnc: Varchar(255)\nUnc: Float(8)\nUnc: Float(8)\nUnc: Float(8)\nUnc: Integer(8)\nUnc: Float(8)\nUnc: Float(8)\nUnc: Float(8)\nUnc: Float(8)\nUnc: Float(8)\nUnc: Timestamp(8)\nUnc: Varchar(255)\nUnc: Varchar(255)\nUnc: Float(8)\nUnc: Float(8)\nUnc: Varchar(255)\nUnc: TimestampTz(8)\nUnc: Integer(8)"", color = ""purple"", shape = ""box""];"
"7[label = ""ScanStep: gametransaction_super\nSIP1(HashJoin): gametransaction.gameTransactionId\namountReal_eur\ngameTransactionId\njackpotAmount_base\nwalletAmount\nbetslipId\nreason\njackpotContribution_base\nproviderSportsbookId\nbalanceAfter_eur\nfxSpread\njackpotAmount\nsportsbook\nproviderAmount\namount_eur\navailableBalanceAfter_base\navailableBalanceAfterBonus_eur\navailableBalanceAfterReal_base\navailableBalanceAfterBonus_base\nbalanceAfterBonus_base\namountBonus\ndetails\nproviderGameTransactionId\nwalletAmount_eur\ndiscardable\n_CELONIS_INPUT_FILE\njackpotContribution\nterminalRef\nshopRef\nsportsbookWinnings_base\nfxRate\navailableBalanceAfter_eur\nbalanceAfter_base\nsessionId\nstatus\nsportsbookWinnings_eur\nbetslipSettledAt\nsportsbookStatus\nbalanceAfter\ntransactionReason\nbetslip\ntaxAmount\ndevice\nsucceededAt\npromotionId\nsportsbookId\ntaxAmount_eur\ntaxAmount_base\navailableBalanceAfterBonus\nversion\npromotional\nbalanceAfterBonus\ngameTransactionType\nproviderGameSessionId\ncurrencyCode\namount\nuserId\nproviderAmount_eur\njackpotContribution_eur\nerrorCode\nmessage\nwalletAmount_base\nprocessedAt\nprovider\nsyndicateSessionId\nbetslipWinnings_eur\navailableBalanceAfterReal\ngameRoundId\nbetslipStatus\nbalanceAfterReal\nstudio\navailableBalanceAfterReal_eur\namountReal_base\nbetslipWinnings_base\nupdatedAt\ngameSessionId\namountBonus_base\ncode\nproviderAmount_base\nproviderRoundId\nproviderBetslipId\namount_base\nbalanceAfterReal_base\navailableBalanceAfter\ngameRoundIndex\nbalanceAfterReal_eur\njackpotAmount_eur\namountReal\nbetslipWinnings\nsportsbookWinnings\ncreatedAt\namounts\ngameId\nbalanceAfterBonus_eur\namountBonus_eur\nwalletCurrencyCode\n_CELONIS_CHANGE_DATE\nepoch\nUnc: Float(8)\nUnc: Varchar(255)\nUnc: Float(8)\nUnc: Float(8)\nUnc: Varchar(255)\nUnc: Varchar(255)\nUnc: Float(8)\nUnc: Varchar(255)\nUnc: Float(8)\nUnc: Float(8)\nUnc: Float(8)\nUnc: Varchar(255)\nUnc: Float(8)\nUnc: Float(8)\nUnc: Float(8)\nUnc: Float(8)\nUnc: Float(8)\nUnc: Float(8)\nUnc: Float(8)\nUnc: Float(8)\nUnc: Varchar(255)\nUnc: Varchar(255)\nUnc: Float(8)\nUnc: Boolean(1)\nUnc: Varchar(255)\nUnc: Float(8)\nUnc: Varchar(255)\nUnc: Varchar(255)\nUnc: Float(8)\nUnc: Float(8)\nUnc: Float(8)\nUnc: Float(8)\nUnc: Varchar(255)\nUnc: Varchar(255)\nUnc: Float(8)\nUnc: Timestamp(8)\nUnc: Varchar(255)\nUnc: Float(8)\nUnc: Varchar(255)\nUnc: Varchar(255)\nUnc: Float(8)\nUnc: Varchar(255)\nUnc: Timestamp(8)\nUnc: Varchar(255)\nUnc: Varchar(255)\nUnc: Float(8)\nUnc: Float(8)\nUnc: Float(8)\nUnc: Integer(8)\nUnc: Boolean(1)\nUnc: Float(8)\nUnc: Varchar(255)\nUnc: Varchar(255)\nUnc: Varchar(255)\nUnc: Float(8)\nUnc: Varchar(255)\nUnc: Float(8)\nUnc: Float(8)\nUnc: Varchar(255)\nUnc: Varchar(255)\nUnc: Float(8)\nUnc: Timestamp(8)\nUnc: Varchar(255)\nUnc: Varchar(255)\nUnc: Float(8)\nUnc: Float(8)\nUnc: Varchar(255)\nUnc: Varchar(255)\nUnc: Float(8)\nUnc: Varchar(255)\nUnc: Float(8)\nUnc: Float(8)\nUnc: Float(8)\nUnc: Timestamp(8)\nUnc: Varchar(255)\nUnc: Float(8)\nUnc: Varchar(255)\nUnc: Float(8)\nUnc: Varchar(255)\nUnc: Varchar(255)\nUnc: Float(8)\nUnc: Float(8)\nUnc: Float(8)\nUnc: Integer(8)\nUnc: Float(8)\nUnc: Float(8)\nUnc: Float(8)\nUnc: Float(8)\nUnc: Float(8)\nUnc: Timestamp(8)\nUnc: Varchar(255)\nUnc: Varchar(255)\nUnc: Float(8)\nUnc: Float(8)\nUnc: Varchar(255)\nUnc: TimestampTz(8)\nUnc: Integer(8)"", color = ""brown"", shape = ""box""];"
"8[label = ""ParallelUnionStep: \nCombine\nUnc: Varchar(81)\nUnc: Varchar(81)\nUnc: Float(8)\nUnc: Float(8)\nUnc: Varchar(81)\nUnc: Varchar(81)\nUnc: Varchar(81)\nUnc: Float(8)\nUnc: Boolean(1)\nUnc: Float(8)\nUnc: Varchar(81)\nUnc: Float(8)\nUnc: Float(8)\nUnc: Timestamp(8)\nUnc: Float(8)\nUnc: Varchar(81)\nUnc: Float(8)\nUnc: Float(8)\nUnc: Float(8)\nUnc: Float(8)\nUnc: Float(8)\nUnc: Float(8)\nUnc: Varchar(81)\nUnc: Float(8)\nUnc: Float(8)\nUnc: Boolean(1)\nUnc: Varchar(81)\nUnc: Float(8)\nUnc: Float(8)\nUnc: Float(8)\nUnc: Timestamp(8)\nUnc: Float(8)\nUnc: Float(8)\nUnc: Varchar(81)\nUnc: Varchar(81)\nUnc: Float(8)\nUnc: Float(8)\nUnc: Float(8)\nUnc: Varchar(81)\nUnc: Float(8)\nUnc: Float(8)\nUnc: Varchar(81)\nUnc: Varchar(81)\nUnc: Varchar(81)\nUnc: Float(8)\nUnc: Varchar(81)\nUnc: Varchar(81)\nUnc: Float(8)\nUnc: Varchar(81)\nUnc: Float(8)\nUnc: Float(8)\nUnc: Timestamp(8)\nUnc: Varchar(81)\nUnc: Varchar(81)\nUnc: Varchar(81)\nUnc: Float(8)\nUnc: Varchar(81)\nUnc: Float(8)\nUnc: Varchar(81)\nUnc: Float(8)\nUnc: Varchar(81)\nUnc: Float(8)\nUnc: Float(8)\nUnc: Varchar(81)\nUnc: Float(8)\nUnc: Float(8)\nUnc: Varchar(81)\nUnc: Timestamp(8)\nUnc: Varchar(81)\nUnc: Varchar(81)\nUnc: Float(8)\nUnc: Float(8)\nUnc: Varchar(81)\nUnc: Integer(8)\nUnc: Float(8)\nUnc: Float(8)\nUnc: Varchar(81)\nUnc: Float(8)\nUnc: Float(8)\nUnc: Timestamp(8)\nUnc: Float(8)\nUnc: Integer(8)\nUnc: Varchar(81)\nUnc: Float(8)\nUnc: Varchar(81)\nUnc: Float(8)\nUnc: Varchar(81)\nUnc: Varchar(81)\nUnc: Float(8)\nUnc: Float(8)\nUnc: Float(8)\nUnc: Float(8)\nUnc: Varchar(81)\nUnc: Varchar(81)\nUnc: Float(8)\nUnc: Boolean(1)"", color = ""green"", shape = ""box""];"
"9[label = ""ExprEval: \n input.device\n input.promotionId\n input.providerAmount\n input.availableBalanceAfterReal_base\n input.sportsbookId\n input.amounts\n input.currencyCode\n input.jackpotContribution\n input.promotional\n input.amountReal_base\n input.providerGameSessionId\n input.betslipWinnings_base\n input.walletAmount_eur\n input.betslipSettledAt\n input.jackpotAmount\n input.provider\n input.balanceAfterBonus_base\n input.amountReal\n input.walletAmount_base\n input.balanceAfterBonus_eur\n input.balanceAfterReal_base\n input.betslipWinnings\n input.gameTransactionType\n input.walletAmount\n input.balanceAfterReal\n input.discardable\n input.message\n input.amount\n input.sportsbookWinnings_base\n input.jackpotContribution_base\n input.updatedAt\n input.availableBalanceAfterBonus_eur\n input.taxAmount_eur\n input.gameRoundId\n input.providerGameTransactionId\n input.balanceAfter_base\n input.sportsbookWinnings_eur\n input.availableBalanceAfterBonus\n input.code\n input.amountReal_eur\n input.availableBalanceAfter_eur\n input.gameId\n input.syndicateSessionId\n input.gameSessionId\n input.amount_eur\n input.providerRoundId\n input.errorCode\n input.availableBalanceAfterReal\n input.betslipId\n input.fxSpread\n input.balanceAfter_eur\n input.processedAt\n input.providerBetslipId\n input.betslipStatus\n input.walletCurrencyCode\n input.fxRate\n input.gameTransactionId\n input.providerAmount_base\n input.sportsbookStatus\n input.balanceAfterReal_eur\n input.reason\n input.jackpotContribution_eur\n input.amountBonus\n input.providerSportsbookId\n input.providerAmount_eur\n input.balanceAfter\n input.details\n input.createdAt\n input.sportsbook\n input.studio\n input.amountBonus_eur\n input.availableBalanceAfterBonus_base\n input._CELONIS_INPUT_FILE\n input.version\n input.taxAmount_base\n input.jackpotAmount_base\n input.shopRef\n input.taxAmount\n input.jackpotAmount_eur\n input.succeededAt\n input.sportsbookWinnings\n input.gameRoundIndex\n input.terminalRef\n input.amountBonus_base\n input.userId\n input.balanceAfterBonus\n input.betslip\n input.transactionReason\n input.availableBalanceAfter_base\n input.betslipWinnings_eur\n input.availableBalanceAfterReal_eur\n input.availableBalanceAfter\n input.status\n input.sessionId\n input.amount_base\n true\nUnc: Varchar(81)\nUnc: Varchar(81)\nUnc: Float(8)\nUnc: Float(8)\nUnc: Varchar(81)\nUnc: Varchar(81)\nUnc: Varchar(81)\nUnc: Float(8)\nUnc: Boolean(1)\nUnc: Float(8)\nUnc: Varchar(81)\nUnc: Float(8)\nUnc: Float(8)\nUnc: Timestamp(8)\nUnc: Float(8)\nUnc: Varchar(81)\nUnc: Float(8)\nUnc: Float(8)\nUnc: Float(8)\nUnc: Float(8)\nUnc: Float(8)\nUnc: Float(8)\nUnc: Varchar(81)\nUnc: Float(8)\nUnc: Float(8)\nUnc: Boolean(1)\nUnc: Varchar(81)\nUnc: Float(8)\nUnc: Float(8)\nUnc: Float(8)\nUnc: Timestamp(8)\nUnc: Float(8)\nUnc: Float(8)\nUnc: Varchar(81)\nUnc: Varchar(81)\nUnc: Float(8)\nUnc: Float(8)\nUnc: Float(8)\nUnc: Varchar(81)\nUnc: Float(8)\nUnc: Float(8)\nUnc: Varchar(81)\nUnc: Varchar(81)\nUnc: Varchar(81)\nUnc: Float(8)\nUnc: Varchar(81)\nUnc: Varchar(81)\nUnc: Float(8)\nUnc: Varchar(81)\nUnc: Float(8)\nUnc: Float(8)\nUnc: Timestamp(8)\nUnc: Varchar(81)\nUnc: Varchar(81)\nUnc: Varchar(81)\nUnc: Float(8)\nUnc: Varchar(81)\nUnc: Float(8)\nUnc: Varchar(81)\nUnc: Float(8)\nUnc: Varchar(81)\nUnc: Float(8)\nUnc: Float(8)\nUnc: Varchar(81)\nUnc: Float(8)\nUnc: Float(8)\nUnc: Varchar(81)\nUnc: Timestamp(8)\nUnc: Varchar(81)\nUnc: Varchar(81)\nUnc: Float(8)\nUnc: Float(8)\nUnc: Varchar(81)\nUnc: Integer(8)\nUnc: Float(8)\nUnc: Float(8)\nUnc: Varchar(81)\nUnc: Float(8)\nUnc: Float(8)\nUnc: Timestamp(8)\nUnc: Float(8)\nUnc: Integer(8)\nUnc: Varchar(81)\nUnc: Float(8)\nUnc: Varchar(81)\nUnc: Float(8)\nUnc: Varchar(81)\nUnc: Varchar(81)\nUnc: Float(8)\nUnc: Float(8)\nUnc: Float(8)\nUnc: Float(8)\nUnc: Varchar(81)\nUnc: Varchar(81)\nUnc: Float(8)\nUnc: Boolean(1)"", color = ""green"", shape = ""box""];"
"10[label = ""ExprEval: \n _CELONIS_TMP_gametransaction.device\n _CELONIS_TMP_gametransaction.promotionId\n _CELONIS_TMP_gametransaction.providerAmount\n _CELONIS_TMP_gametransaction.availableBalanceAfterReal_base\n _CELONIS_TMP_gametransaction.sportsbookId\n _CELONIS_TMP_gametransaction.amounts\n _CELONIS_TMP_gametransaction.currencyCode\n _CELONIS_TMP_gametransaction.jackpotContribution\n _CELONIS_TMP_gametransaction.promotional\n _CELONIS_TMP_gametransaction.amountReal_base\n _CELONIS_TMP_gametransaction.providerGameSessionId\n _CELONIS_TMP_gametransaction.betslipWinnings_base\n _CELONIS_TMP_gametransaction.walletAmount_eur\n _CELONIS_TMP_gametransaction.betslipSettledAt\n _CELONIS_TMP_gametransaction.jackpotAmount\n _CELONIS_TMP_gametransaction.provider\n _CELONIS_TMP_gametransaction.balanceAfterBonus_base\n _CELONIS_TMP_gametransaction.amountReal\n _CELONIS_TMP_gametransaction.walletAmount_base\n _CELONIS_TMP_gametransaction.balanceAfterBonus_eur\n _CELONIS_TMP_gametransaction.balanceAfterReal_base\n _CELONIS_TMP_gametransaction.betslipWinnings\n _CELONIS_TMP_gametransaction.gameTransactionType\n _CELONIS_TMP_gametransaction.walletAmount\n _CELONIS_TMP_gametransaction.balanceAfterReal\n _CELONIS_TMP_gametransaction.discardable\n _CELONIS_TMP_gametransaction.message\n _CELONIS_TMP_gametransaction.amount\n _CELONIS_TMP_gametransaction.sportsbookWinnings_base\n _CELONIS_TMP_gametransaction.jackpotContribution_base\n _CELONIS_TMP_gametransaction.updatedAt\n _CELONIS_TMP_gametransaction.availableBalanceAfterBonus_eur\n _CELONIS_TMP_gametransaction.taxAmount_eur\n _CELONIS_TMP_gametransaction.gameRoundId\n _CELONIS_TMP_gametransaction.providerGameTransactionId\n _CELONIS_TMP_gametransaction.balanceAfter_base\n _CELONIS_TMP_gametransaction.sportsbookWinnings_eur\n _CELONIS_TMP_gametransaction.availableBalanceAfterBonus\n _CELONIS_TMP_gametransaction.code\n _CELONIS_TMP_gametransaction.amountReal_eur\n _CELONIS_TMP_gametransaction.availableBalanceAfter_eur\n _CELONIS_TMP_gametransaction.gameId\n _CELONIS_TMP_gametransaction.syndicateSessionId\n _CELONIS_TMP_gametransaction.gameSessionId\n _CELONIS_TMP_gametransaction.amount_eur\n _CELONIS_TMP_gametransaction.providerRoundId\n _CELONIS_TMP_gametransaction.errorCode\n _CELONIS_TMP_gametransaction.availableBalanceAfterReal\n _CELONIS_TMP_gametransaction.betslipId\n _CELONIS_TMP_gametransaction.fxSpread\n _CELONIS_TMP_gametransaction.balanceAfter_eur\n _CELONIS_TMP_gametransaction.processedAt\n _CELONIS_TMP_gametransaction.providerBetslipId\n _CELONIS_TMP_gametransaction.betslipStatus\n _CELONIS_TMP_gametransaction.walletCurrencyCode\n _CELONIS_TMP_gametransaction.fxRate\n _CELONIS_TMP_gametransaction.gameTransactionId\n _CELONIS_TMP_gametransaction.providerAmount_base\n _CELONIS_TMP_gametransaction.sportsbookStatus\n _CELONIS_TMP_gametransaction.balanceAfterReal_eur\n _CELONIS_TMP_gametransaction.reason\n _CELONIS_TMP_gametransaction.jackpotContribution_eur\n _CELONIS_TMP_gametransaction.amountBonus\n _CELONIS_TMP_gametransaction.providerSportsbookId\n _CELONIS_TMP_gametransaction.providerAmount_eur\n _CELONIS_TMP_gametransaction.balanceAfter\n _CELONIS_TMP_gametransaction.details\n _CELONIS_TMP_gametransaction.createdAt\n _CELONIS_TMP_gametransaction.sportsbook\n _CELONIS_TMP_gametransaction.studio\n _CELONIS_TMP_gametransaction.amountBonus_eur\n _CELONIS_TMP_gametransaction.availableBalanceAfterBonus_base\n _CELONIS_TMP_gametransaction._CELONIS_INPUT_FILE\n _CELONIS_TMP_gametransaction.version\n _CELONIS_TMP_gametransaction.taxAmount_base\n _CELONIS_TMP_gametransaction.jackpotAmount_base\n _CELONIS_TMP_gametransaction.shopRef\n _CELONIS_TMP_gametransaction.taxAmount\n _CELONIS_TMP_gametransaction.jackpotAmount_eur\n _CELONIS_TMP_gametransaction.succeededAt\n _CELONIS_TMP_gametransaction.sportsbookWinnings\n _CELONIS_TMP_gametransaction.gameRoundIndex\n _CELONIS_TMP_gametransaction.terminalRef\n _CELONIS_TMP_gametransaction.amountBonus_base\n _CELONIS_TMP_gametransaction.userId\n _CELONIS_TMP_gametransaction.balanceAfterBonus\n _CELONIS_TMP_gametransaction.betslip\n _CELONIS_TMP_gametransaction.transactionReason\n _CELONIS_TMP_gametransaction.availableBalanceAfter_base\n _CELONIS_TMP_gametransaction.betslipWinnings_eur\n _CELONIS_TMP_gametransaction.availableBalanceAfterReal_eur\n _CELONIS_TMP_gametransaction.availableBalanceAfter\n _CELONIS_TMP_gametransaction.status\n _CELONIS_TMP_gametransaction.sessionId\n _CELONIS_TMP_gametransaction.amount_base\nUnc: Varchar(81)\nUnc: Varchar(81)\nUnc: Float(8)\nUnc: Float(8)\nUnc: Varchar(81)\nUnc: Varchar(81)\nUnc: Varchar(81)\nUnc: Float(8)\nUnc: Boolean(1)\nUnc: Float(8)\nUnc: Varchar(81)\nUnc: Float(8)\nUnc: Float(8)\nUnc: Timestamp(8)\nUnc: Float(8)\nUnc: Varchar(81)\nUnc: Float(8)\nUnc: Float(8)\nUnc: Float(8)\nUnc: Float(8)\nUnc: Float(8)\nUnc: Float(8)\nUnc: Varchar(81)\nUnc: Float(8)\nUnc: Float(8)\nUnc: Boolean(1)\nUnc: Varchar(81)\nUnc: Float(8)\nUnc: Float(8)\nUnc: Float(8)\nUnc: Timestamp(8)\nUnc: Float(8)\nUnc: Float(8)\nUnc: Varchar(81)\nUnc: Varchar(81)\nUnc: Float(8)\nUnc: Float(8)\nUnc: Float(8)\nUnc: Varchar(81)\nUnc: Float(8)\nUnc: Float(8)\nUnc: Varchar(81)\nUnc: Varchar(81)\nUnc: Varchar(81)\nUnc: Float(8)\nUnc: Varchar(81)\nUnc: Varchar(81)\nUnc: Float(8)\nUnc: Varchar(81)\nUnc: Float(8)\nUnc: Float(8)\nUnc: Timestamp(8)\nUnc: Varchar(81)\nUnc: Varchar(81)\nUnc: Varchar(81)\nUnc: Float(8)\nUnc: Varchar(81)\nUnc: Float(8)\nUnc: Varchar(81)\nUnc: Float(8)\nUnc: Varchar(81)\nUnc: Float(8)\nUnc: Float(8)\nUnc: Varchar(81)\nUnc: Float(8)\nUnc: Float(8)\nUnc: Varchar(81)\nUnc: Timestamp(8)\nUnc: Varchar(81)\nUnc: Varchar(81)\nUnc: Float(8)\nUnc: Float(8)\nUnc: Varchar(81)\nUnc: Integer(8)\nUnc: Float(8)\nUnc: Float(8)\nUnc: Varchar(81)\nUnc: Float(8)\nUnc: Float(8)\nUnc: Timestamp(8)\nUnc: Float(8)\nUnc: Integer(8)\nUnc: Varchar(81)\nUnc: Float(8)\nUnc: Varchar(81)\nUnc: Float(8)\nUnc: Varchar(81)\nUnc: Varchar(81)\nUnc: Float(8)\nUnc: Float(8)\nUnc: Float(8)\nUnc: Float(8)\nUnc: Varchar(81)\nUnc: Varchar(81)\nUnc: Float(8)"", color = ""green"", shape = ""box""];"
"11[label = ""TopK[PIPELINED]\n Sort: (keys = Ax2,Nx94)\nPartitionKeys: 1\nSortKeys: 2\nLIMIT: 1\nOffset: 0\nUnc: Varchar(81)\nUnc: Integer(8)\nUnc: Varchar(81)\nUnc: Varchar(81)\nUnc: Float(8)\nUnc: Float(8)\nUnc: Varchar(81)\nUnc: Varchar(81)\nUnc: Varchar(81)\nUnc: Float(8)\nUnc: Boolean(1)\nUnc: Float(8)\nUnc: Varchar(81)\nUnc: Float(8)\nUnc: Float(8)\nUnc: Timestamp(8)\nUnc: Float(8)\nUnc: Varchar(81)\nUnc: Float(8)\nUnc: Float(8)\nUnc: Float(8)\nUnc: Float(8)\nUnc: Float(8)\nUnc: Float(8)\nUnc: Varchar(81)\nUnc: Float(8)\nUnc: Float(8)\nUnc: Boolean(1)\nUnc: Varchar(81)\nUnc: Float(8)\nUnc: Float(8)\nUnc: Float(8)\nUnc: Timestamp(8)\nUnc: Float(8)\nUnc: Float(8)\nUnc: Varchar(81)\nUnc: Varchar(81)\nUnc: Float(8)\nUnc: Float(8)\nUnc: Float(8)\nUnc: Varchar(81)\nUnc: Float(8)\nUnc: Float(8)\nUnc: Varchar(81)\nUnc: Varchar(81)\nUnc: Varchar(81)\nUnc: Float(8)\nUnc: Varchar(81)\nUnc: Varchar(81)\nUnc: Float(8)\nUnc: Varchar(81)\nUnc: Float(8)\nUnc: Float(8)\nUnc: Timestamp(8)\nUnc: Varchar(81)\nUnc: Varchar(81)\nUnc: Varchar(81)\nUnc: Float(8)\nUnc: Float(8)\nUnc: Varchar(81)\nUnc: Float(8)\nUnc: Varchar(81)\nUnc: Float(8)\nUnc: Float(8)\nUnc: Varchar(81)\nUnc: Float(8)\nUnc: Float(8)\nUnc: Varchar(81)\nUnc: Timestamp(8)\nUnc: Varchar(81)\nUnc: Varchar(81)\nUnc: Float(8)\nUnc: Float(8)\nUnc: Varchar(81)\nUnc: Integer(8)\nUnc: Float(8)\nUnc: Float(8)\nUnc: Varchar(81)\nUnc: Float(8)\nUnc: Float(8)\nUnc: Timestamp(8)\nUnc: Float(8)\nUnc: Integer(8)\nUnc: Varchar(81)\nUnc: Float(8)\nUnc: Varchar(81)\nUnc: Float(8)\nUnc: Varchar(81)\nUnc: Varchar(81)\nUnc: Float(8)\nUnc: Float(8)\nUnc: Float(8)\nUnc: Float(8)\nUnc: Varchar(81)\nUnc: Varchar(81)\nUnc: Float(8)"", color = ""green"", shape = ""box""];"
"12[label = ""ExprEval: \n _CELONIS_TMP_gametransaction.gameTransactionId\n 1\n _CELONIS_TMP_gametransaction.device\n _CELONIS_TMP_gametransaction.promotionId\n _CELONIS_TMP_gametransaction.providerAmount\n _CELONIS_TMP_gametransaction.availableBalanceAfterReal_base\n _CELONIS_TMP_gametransaction.sportsbookId\n _CELONIS_TMP_gametransaction.amounts\n _CELONIS_TMP_gametransaction.currencyCode\n _CELONIS_TMP_gametransaction.jackpotContribution\n _CELONIS_TMP_gametransaction.promotional\n _CELONIS_TMP_gametransaction.amountReal_base\n _CELONIS_TMP_gametransaction.providerGameSessionId\n _CELONIS_TMP_gametransaction.betslipWinnings_base\n _CELONIS_TMP_gametransaction.walletAmount_eur\n _CELONIS_TMP_gametransaction.betslipSettledAt\n _CELONIS_TMP_gametransaction.jackpotAmount\n _CELONIS_TMP_gametransaction.provider\n _CELONIS_TMP_gametransaction.balanceAfterBonus_base\n _CELONIS_TMP_gametransaction.amountReal\n _CELONIS_TMP_gametransaction.walletAmount_base\n _CELONIS_TMP_gametransaction.balanceAfterBonus_eur\n _CELONIS_TMP_gametransaction.balanceAfterReal_base\n _CELONIS_TMP_gametransaction.betslipWinnings\n _CELONIS_TMP_gametransaction.gameTransactionType\n _CELONIS_TMP_gametransaction.walletAmount\n _CELONIS_TMP_gametransaction.balanceAfterReal\n _CELONIS_TMP_gametransaction.discardable\n _CELONIS_TMP_gametransaction.message\n _CELONIS_TMP_gametransaction.amount\n _CELONIS_TMP_gametransaction.sportsbookWinnings_base\n _CELONIS_TMP_gametransaction.jackpotContribution_base\n _CELONIS_TMP_gametransaction.updatedAt\n _CELONIS_TMP_gametransaction.availableBalanceAfterBonus_eur\n _CELONIS_TMP_gametransaction.taxAmount_eur\n _CELONIS_TMP_gametransaction.gameRoundId\n _CELONIS_TMP_gametransaction.providerGameTransactionId\n _CELONIS_TMP_gametransaction.balanceAfter_base\n _CELONIS_TMP_gametransaction.sportsbookWinnings_eur\n _CELONIS_TMP_gametransaction.availableBalanceAfterBonus\n _CELONIS_TMP_gametransaction.code\n _CELONIS_TMP_gametransaction.amountReal_eur\n _CELONIS_TMP_gametransaction.availableBalanceAfter_eur\n _CELONIS_TMP_gametransaction.gameId\n _CELONIS_TMP_gametransaction.syndicateSessionId\n _CELONIS_TMP_gametransaction.gameSessionId\n _CELONIS_TMP_gametransaction.amount_eur\n _CELONIS_TMP_gametransaction.providerRoundId\n _CELONIS_TMP_gametransaction.errorCode\n _CELONIS_TMP_gametransaction.availableBalanceAfterReal\n _CELONIS_TMP_gametransaction.betslipId\n _CELONIS_TMP_gametransaction.fxSpread\n _CELONIS_TMP_gametransaction.balanceAfter_eur\n _CELONIS_TMP_gametransaction.processedAt\n _CELONIS_TMP_gametransaction.providerBetslipId\n _CELONIS_TMP_gametransaction.betslipStatus\n _CELONIS_TMP_gametransaction.walletCurrencyCode\n _CELONIS_TMP_gametransaction.fxRate\n _CELONIS_TMP_gametransaction.providerAmount_base\n _CELONIS_TMP_gametransaction.sportsbookStatus\n _CELONIS_TMP_gametransaction.balanceAfterReal_eur\n _CELONIS_TMP_gametransaction.reason\n _CELONIS_TMP_gametransaction.jackpotContribution_eur\n _CELONIS_TMP_gametransaction.amountBonus\n _CELONIS_TMP_gametransaction.providerSportsbookId\n _CELONIS_TMP_gametransaction.providerAmount_eur\n _CELONIS_TMP_gametransaction.balanceAfter\n _CELONIS_TMP_gametransaction.details\n _CELONIS_TMP_gametransaction.createdAt\n _CELONIS_TMP_gametransaction.sportsbook\n _CELONIS_TMP_gametransaction.studio\n _CELONIS_TMP_gametransaction.amountBonus_eur\n _CELONIS_TMP_gametransaction.availableBalanceAfterBonus_base\n _CELONIS_TMP_gametransaction._CELONIS_INPUT_FILE\n _CELONIS_TMP_gametransaction.version\n _CELONIS_TMP_gametransaction.taxAmount_base\n _CELONIS_TMP_gametransaction.jackpotAmount_base\n _CELONIS_TMP_gametransaction.shopRef\n _CELONIS_TMP_gametransaction.taxAmount\n _CELONIS_TMP_gametransaction.jackpotAmount_eur\n _CELONIS_TMP_gametransaction.succeededAt\n _CELONIS_TMP_gametransaction.sportsbookWinnings\n _CELONIS_TMP_gametransaction.gameRoundIndex\n _CELONIS_TMP_gametransaction.terminalRef\n _CELONIS_TMP_gametransaction.amountBonus_base\n _CELONIS_TMP_gametransaction.userId\n _CELONIS_TMP_gametransaction.balanceAfterBonus\n _CELONIS_TMP_gametransaction.betslip\n _CELONIS_TMP_gametransaction.transactionReason\n _CELONIS_TMP_gametransaction.availableBalanceAfter_base\n _CELONIS_TMP_gametransaction.betslipWinnings_eur\n _CELONIS_TMP_gametransaction.availableBalanceAfterReal_eur\n _CELONIS_TMP_gametransaction.availableBalanceAfter\n _CELONIS_TMP_gametransaction.status\n _CELONIS_TMP_gametransaction.sessionId\n _CELONIS_TMP_gametransaction.amount_base\nUnc: Varchar(81)\nUnc: Integer(8)\nUnc: Varchar(81)\nUnc: Varchar(81)\nUnc: Float(8)\nUnc: Float(8)\nUnc: Varchar(81)\nUnc: Varchar(81)\nUnc: Varchar(81)\nUnc: Float(8)\nUnc: Boolean(1)\nUnc: Float(8)\nUnc: Varchar(81)\nUnc: Float(8)\nUnc: Float(8)\nUnc: Timestamp(8)\nUnc: Float(8)\nUnc: Varchar(81)\nUnc: Float(8)\nUnc: Float(8)\nUnc: Float(8)\nUnc: Float(8)\nUnc: Float(8)\nUnc: Float(8)\nUnc: Varchar(81)\nUnc: Float(8)\nUnc: Float(8)\nUnc: Boolean(1)\nUnc: Varchar(81)\nUnc: Float(8)\nUnc: Float(8)\nUnc: Float(8)\nUnc: Timestamp(8)\nUnc: Float(8)\nUnc: Float(8)\nUnc: Varchar(81)\nUnc: Varchar(81)\nUnc: Float(8)\nUnc: Float(8)\nUnc: Float(8)\nUnc: Varchar(81)\nUnc: Float(8)\nUnc: Float(8)\nUnc: Varchar(81)\nUnc: Varchar(81)\nUnc: Varchar(81)\nUnc: Float(8)\nUnc: Varchar(81)\nUnc: Varchar(81)\nUnc: Float(8)\nUnc: Varchar(81)\nUnc: Float(8)\nUnc: Float(8)\nUnc: Timestamp(8)\nUnc: Varchar(81)\nUnc: Varchar(81)\nUnc: Varchar(81)\nUnc: Float(8)\nUnc: Float(8)\nUnc: Varchar(81)\nUnc: Float(8)\nUnc: Varchar(81)\nUnc: Float(8)\nUnc: Float(8)\nUnc: Varchar(81)\nUnc: Float(8)\nUnc: Float(8)\nUnc: Varchar(81)\nUnc: Timestamp(8)\nUnc: Varchar(81)\nUnc: Varchar(81)\nUnc: Float(8)\nUnc: Float(8)\nUnc: Varchar(81)\nUnc: Integer(8)\nUnc: Float(8)\nUnc: Float(8)\nUnc: Varchar(81)\nUnc: Float(8)\nUnc: Float(8)\nUnc: Timestamp(8)\nUnc: Float(8)\nUnc: Integer(8)\nUnc: Varchar(81)\nUnc: Float(8)\nUnc: Varchar(81)\nUnc: Float(8)\nUnc: Varchar(81)\nUnc: Varchar(81)\nUnc: Float(8)\nUnc: Float(8)\nUnc: Float(8)\nUnc: Float(8)\nUnc: Varchar(81)\nUnc: Varchar(81)\nUnc: Float(8)"", color = ""green"", shape = ""box""];"
"13[label = ""Sort: (keys = Ax2,Nx94)\nUnc: Varchar(81)\nUnc: Integer(8)\nUnc: Varchar(81)\nUnc: Varchar(81)\nUnc: Float(8)\nUnc: Float(8)\nUnc: Varchar(81)\nUnc: Varchar(81)\nUnc: Varchar(81)\nUnc: Float(8)\nUnc: Boolean(1)\nUnc: Float(8)\nUnc: Varchar(81)\nUnc: Float(8)\nUnc: Float(8)\nUnc: Timestamp(8)\nUnc: Float(8)\nUnc: Varchar(81)\nUnc: Float(8)\nUnc: Float(8)\nUnc: Float(8)\nUnc: Float(8)\nUnc: Float(8)\nUnc: Float(8)\nUnc: Varchar(81)\nUnc: Float(8)\nUnc: Float(8)\nUnc: Boolean(1)\nUnc: Varchar(81)\nUnc: Float(8)\nUnc: Float(8)\nUnc: Float(8)\nUnc: Timestamp(8)\nUnc: Float(8)\nUnc: Float(8)\nUnc: Varchar(81)\nUnc: Varchar(81)\nUnc: Float(8)\nUnc: Float(8)\nUnc: Float(8)\nUnc: Varchar(81)\nUnc: Float(8)\nUnc: Float(8)\nUnc: Varchar(81)\nUnc: Varchar(81)\nUnc: Varchar(81)\nUnc: Float(8)\nUnc: Varchar(81)\nUnc: Varchar(81)\nUnc: Float(8)\nUnc: Varchar(81)\nUnc: Float(8)\nUnc: Float(8)\nUnc: Timestamp(8)\nUnc: Varchar(81)\nUnc: Varchar(81)\nUnc: Varchar(81)\nUnc: Float(8)\nUnc: Float(8)\nUnc: Varchar(81)\nUnc: Float(8)\nUnc: Varchar(81)\nUnc: Float(8)\nUnc: Float(8)\nUnc: Varchar(81)\nUnc: Float(8)\nUnc: Float(8)\nUnc: Varchar(81)\nUnc: Timestamp(8)\nUnc: Varchar(81)\nUnc: Varchar(81)\nUnc: Float(8)\nUnc: Float(8)\nUnc: Varchar(81)\nUnc: Integer(8)\nUnc: Float(8)\nUnc: Float(8)\nUnc: Varchar(81)\nUnc: Float(8)\nUnc: Float(8)\nUnc: Timestamp(8)\nUnc: Float(8)\nUnc: Integer(8)\nUnc: Varchar(81)\nUnc: Float(8)\nUnc: Varchar(81)\nUnc: Float(8)\nUnc: Varchar(81)\nUnc: Varchar(81)\nUnc: Float(8)\nUnc: Float(8)\nUnc: Float(8)\nUnc: Float(8)\nUnc: Varchar(81)\nUnc: Varchar(81)\nUnc: Float(8)"", color = ""green"", shape = ""box""];"
"14[label = ""ExprEval: \n _CELONIS_TMP_gametransaction.gameTransactionId\n 1\n _CELONIS_TMP_gametransaction.device\n _CELONIS_TMP_gametransaction.promotionId\n _CELONIS_TMP_gametransaction.providerAmount\n _CELONIS_TMP_gametransaction.availableBalanceAfterReal_base\n _CELONIS_TMP_gametransaction.sportsbookId\n _CELONIS_TMP_gametransaction.amounts\n _CELONIS_TMP_gametransaction.currencyCode\n _CELONIS_TMP_gametransaction.jackpotContribution\n _CELONIS_TMP_gametransaction.promotional\n _CELONIS_TMP_gametransaction.amountReal_base\n _CELONIS_TMP_gametransaction.providerGameSessionId\n _CELONIS_TMP_gametransaction.betslipWinnings_base\n _CELONIS_TMP_gametransaction.walletAmount_eur\n _CELONIS_TMP_gametransaction.betslipSettledAt\n _CELONIS_TMP_gametransaction.jackpotAmount\n _CELONIS_TMP_gametransaction.provider\n _CELONIS_TMP_gametransaction.balanceAfterBonus_base\n _CELONIS_TMP_gametransaction.amountReal\n _CELONIS_TMP_gametransaction.walletAmount_base\n _CELONIS_TMP_gametransaction.balanceAfterBonus_eur\n _CELONIS_TMP_gametransaction.balanceAfterReal_base\n _CELONIS_TMP_gametransaction.betslipWinnings\n _CELONIS_TMP_gametransaction.gameTransactionType\n _CELONIS_TMP_gametransaction.walletAmount\n _CELONIS_TMP_gametransaction.balanceAfterReal\n _CELONIS_TMP_gametransaction.discardable\n _CELONIS_TMP_gametransaction.message\n _CELONIS_TMP_gametransaction.amount\n _CELONIS_TMP_gametransaction.sportsbookWinnings_base\n _CELONIS_TMP_gametransaction.jackpotContribution_base\n _CELONIS_TMP_gametransaction.updatedAt\n _CELONIS_TMP_gametransaction.availableBalanceAfterBonus_eur\n _CELONIS_TMP_gametransaction.taxAmount_eur\n _CELONIS_TMP_gametransaction.gameRoundId\n _CELONIS_TMP_gametransaction.providerGameTransactionId\n _CELONIS_TMP_gametransaction.balanceAfter_base\n _CELONIS_TMP_gametransaction.sportsbookWinnings_eur\n _CELONIS_TMP_gametransaction.availableBalanceAfterBonus\n _CELONIS_TMP_gametransaction.code\n _CELONIS_TMP_gametransaction.amountReal_eur\n _CELONIS_TMP_gametransaction.availableBalanceAfter_eur\n _CELONIS_TMP_gametransaction.gameId\n _CELONIS_TMP_gametransaction.syndicateSessionId\n _CELONIS_TMP_gametransaction.gameSessionId\n _CELONIS_TMP_gametransaction.amount_eur\n _CELONIS_TMP_gametransaction.providerRoundId\n _CELONIS_TMP_gametransaction.errorCode\n _CELONIS_TMP_gametransaction.availableBalanceAfterReal\n _CELONIS_TMP_gametransaction.betslipId\n _CELONIS_TMP_gametransaction.fxSpread\n _CELONIS_TMP_gametransaction.balanceAfter_eur\n _CELONIS_TMP_gametransaction.processedAt\n _CELONIS_TMP_gametransaction.providerBetslipId\n _CELONIS_TMP_gametransaction.betslipStatus\n _CELONIS_TMP_gametransaction.walletCurrencyCode\n _CELONIS_TMP_gametransaction.fxRate\n _CELONIS_TMP_gametransaction.providerAmount_base\n _CELONIS_TMP_gametransaction.sportsbookStatus\n _CELONIS_TMP_gametransaction.balanceAfterReal_eur\n _CELONIS_TMP_gametransaction.reason\n _CELONIS_TMP_gametransaction.jackpotContribution_eur\n _CELONIS_TMP_gametransaction.amountBonus\n _CELONIS_TMP_gametransaction.providerSportsbookId\n _CELONIS_TMP_gametransaction.providerAmount_eur\n _CELONIS_TMP_gametransaction.balanceAfter\n _CELONIS_TMP_gametransaction.details\n _CELONIS_TMP_gametransaction.createdAt\n _CELONIS_TMP_gametransaction.sportsbook\n _CELONIS_TMP_gametransaction.studio\n _CELONIS_TMP_gametransaction.amountBonus_eur\n _CELONIS_TMP_gametransaction.availableBalanceAfterBonus_base\n _CELONIS_TMP_gametransaction._CELONIS_INPUT_FILE\n _CELONIS_TMP_gametransaction.version\n _CELONIS_TMP_gametransaction.taxAmount_base\n _CELONIS_TMP_gametransaction.jackpotAmount_base\n _CELONIS_TMP_gametransaction.shopRef\n _CELONIS_TMP_gametransaction.taxAmount\n _CELONIS_TMP_gametransaction.jackpotAmount_eur\n _CELONIS_TMP_gametransaction.succeededAt\n _CELONIS_TMP_gametransaction.sportsbookWinnings\n _CELONIS_TMP_gametransaction.gameRoundIndex\n _CELONIS_TMP_gametransaction.terminalRef\n _CELONIS_TMP_gametransaction.amountBonus_base\n _CELONIS_TMP_gametransaction.userId\n _CELONIS_TMP_gametransaction.balanceAfterBonus\n _CELONIS_TMP_gametransaction.betslip\n _CELONIS_TMP_gametransaction.transactionReason\n _CELONIS_TMP_gametransaction.availableBalanceAfter_base\n _CELONIS_TMP_gametransaction.betslipWinnings_eur\n _CELONIS_TMP_gametransaction.availableBalanceAfterReal_eur\n _CELONIS_TMP_gametransaction.availableBalanceAfter\n _CELONIS_TMP_gametransaction.status\n _CELONIS_TMP_gametransaction.sessionId\n _CELONIS_TMP_gametransaction.amount_base\nUnc: Varchar(81)\nUnc: Integer(8)\nUnc: Varchar(81)\nUnc: Varchar(81)\nUnc: Float(8)\nUnc: Float(8)\nUnc: Varchar(81)\nUnc: Varchar(81)\nUnc: Varchar(81)\nUnc: Float(8)\nUnc: Boolean(1)\nUnc: Float(8)\nUnc: Varchar(81)\nUnc: Float(8)\nUnc: Float(8)\nUnc: Timestamp(8)\nUnc: Float(8)\nUnc: Varchar(81)\nUnc: Float(8)\nUnc: Float(8)\nUnc: Float(8)\nUnc: Float(8)\nUnc: Float(8)\nUnc: Float(8)\nUnc: Varchar(81)\nUnc: Float(8)\nUnc: Float(8)\nUnc: Boolean(1)\nUnc: Varchar(81)\nUnc: Float(8)\nUnc: Float(8)\nUnc: Float(8)\nUnc: Timestamp(8)\nUnc: Float(8)\nUnc: Float(8)\nUnc: Varchar(81)\nUnc: Varchar(81)\nUnc: Float(8)\nUnc: Float(8)\nUnc: Float(8)\nUnc: Varchar(81)\nUnc: Float(8)\nUnc: Float(8)\nUnc: Varchar(81)\nUnc: Varchar(81)\nUnc: Varchar(81)\nUnc: Float(8)\nUnc: Varchar(81)\nUnc: Varchar(81)\nUnc: Float(8)\nUnc: Varchar(81)\nUnc: Float(8)\nUnc: Float(8)\nUnc: Timestamp(8)\nUnc: Varchar(81)\nUnc: Varchar(81)\nUnc: Varchar(81)\nUnc: Float(8)\nUnc: Float(8)\nUnc: Varchar(81)\nUnc: Float(8)\nUnc: Varchar(81)\nUnc: Float(8)\nUnc: Float(8)\nUnc: Varchar(81)\nUnc: Float(8)\nUnc: Float(8)\nUnc: Varchar(81)\nUnc: Timestamp(8)\nUnc: Varchar(81)\nUnc: Varchar(81)\nUnc: Float(8)\nUnc: Float(8)\nUnc: Varchar(81)\nUnc: Integer(8)\nUnc: Float(8)\nUnc: Float(8)\nUnc: Varchar(81)\nUnc: Float(8)\nUnc: Float(8)\nUnc: Timestamp(8)\nUnc: Float(8)\nUnc: Integer(8)\nUnc: Varchar(81)\nUnc: Float(8)\nUnc: Varchar(81)\nUnc: Float(8)\nUnc: Varchar(81)\nUnc: Varchar(81)\nUnc: Float(8)\nUnc: Float(8)\nUnc: Float(8)\nUnc: Float(8)\nUnc: Varchar(81)\nUnc: Varchar(81)\nUnc: Float(8)"", color = ""green"", shape = ""box""];"
"15[label = ""TopK[HEAP][PREPASS]\n Sort: (keys = Ax2,Nx94)\nPartitionKeys: 1\nSortKeys: 2\nLIMIT: 1\nUnc: Varchar(81)\nUnc: Integer(8)\nUnc: Varchar(81)\nUnc: Varchar(81)\nUnc: Float(8)\nUnc: Float(8)\nUnc: Varchar(81)\nUnc: Varchar(81)\nUnc: Varchar(81)\nUnc: Float(8)\nUnc: Boolean(1)\nUnc: Float(8)\nUnc: Varchar(81)\nUnc: Float(8)\nUnc: Float(8)\nUnc: Timestamp(8)\nUnc: Float(8)\nUnc: Varchar(81)\nUnc: Float(8)\nUnc: Float(8)\nUnc: Float(8)\nUnc: Float(8)\nUnc: Float(8)\nUnc: Float(8)\nUnc: Varchar(81)\nUnc: Float(8)\nUnc: Float(8)\nUnc: Boolean(1)\nUnc: Varchar(81)\nUnc: Float(8)\nUnc: Float(8)\nUnc: Float(8)\nUnc: Timestamp(8)\nUnc: Float(8)\nUnc: Float(8)\nUnc: Varchar(81)\nUnc: Varchar(81)\nUnc: Float(8)\nUnc: Float(8)\nUnc: Float(8)\nUnc: Varchar(81)\nUnc: Float(8)\nUnc: Float(8)\nUnc: Varchar(81)\nUnc: Varchar(81)\nUnc: Varchar(81)\nUnc: Float(8)\nUnc: Varchar(81)\nUnc: Varchar(81)\nUnc: Float(8)\nUnc: Varchar(81)\nUnc: Float(8)\nUnc: Float(8)\nUnc: Timestamp(8)\nUnc: Varchar(81)\nUnc: Varchar(81)\nUnc: Varchar(81)\nUnc: Float(8)\nUnc: Float(8)\nUnc: Varchar(81)\nUnc: Float(8)\nUnc: Varchar(81)\nUnc: Float(8)\nUnc: Float(8)\nUnc: Varchar(81)\nUnc: Float(8)\nUnc: Float(8)\nUnc: Varchar(81)\nUnc: Timestamp(8)\nUnc: Varchar(81)\nUnc: Varchar(81)\nUnc: Float(8)\nUnc: Float(8)\nUnc: Varchar(81)\nUnc: Integer(8)\nUnc: Float(8)\nUnc: Float(8)\nUnc: Varchar(81)\nUnc: Float(8)\nUnc: Float(8)\nUnc: Timestamp(8)\nUnc: Float(8)\nUnc: Integer(8)\nUnc: Varchar(81)\nUnc: Float(8)\nUnc: Varchar(81)\nUnc: Float(8)\nUnc: Varchar(81)\nUnc: Varchar(81)\nUnc: Float(8)\nUnc: Float(8)\nUnc: Float(8)\nUnc: Float(8)\nUnc: Varchar(81)\nUnc: Varchar(81)\nUnc: Float(8)"", color = ""green"", shape = ""box""];"
"16[label = ""ExprEval: \n _CELONIS_TMP_gametransaction.gameTransactionId\n 1\n _CELONIS_TMP_gametransaction.device\n _CELONIS_TMP_gametransaction.promotionId\n _CELONIS_TMP_gametransaction.providerAmount\n _CELONIS_TMP_gametransaction.availableBalanceAfterReal_base\n _CELONIS_TMP_gametransaction.sportsbookId\n _CELONIS_TMP_gametransaction.amounts\n _CELONIS_TMP_gametransaction.currencyCode\n _CELONIS_TMP_gametransaction.jackpotContribution\n _CELONIS_TMP_gametransaction.promotional\n _CELONIS_TMP_gametransaction.amountReal_base\n _CELONIS_TMP_gametransaction.providerGameSessionId\n _CELONIS_TMP_gametransaction.betslipWinnings_base\n _CELONIS_TMP_gametransaction.walletAmount_eur\n _CELONIS_TMP_gametransaction.betslipSettledAt\n _CELONIS_TMP_gametransaction.jackpotAmount\n _CELONIS_TMP_gametransaction.provider\n _CELONIS_TMP_gametransaction.balanceAfterBonus_base\n _CELONIS_TMP_gametransaction.amountReal\n _CELONIS_TMP_gametransaction.walletAmount_base\n _CELONIS_TMP_gametransaction.balanceAfterBonus_eur\n _CELONIS_TMP_gametransaction.balanceAfterReal_base\n _CELONIS_TMP_gametransaction.betslipWinnings\n _CELONIS_TMP_gametransaction.gameTransactionType\n _CELONIS_TMP_gametransaction.walletAmount\n _CELONIS_TMP_gametransaction.balanceAfterReal\n _CELONIS_TMP_gametransaction.discardable\n _CELONIS_TMP_gametransaction.message\n _CELONIS_TMP_gametransaction.amount\n _CELONIS_TMP_gametransaction.sportsbookWinnings_base\n _CELONIS_TMP_gametransaction.jackpotContribution_base\n _CELONIS_TMP_gametransaction.updatedAt\n _CELONIS_TMP_gametransaction.availableBalanceAfterBonus_eur\n _CELONIS_TMP_gametransaction.taxAmount_eur\n _CELONIS_TMP_gametransaction.gameRoundId\n _CELONIS_TMP_gametransaction.providerGameTransactionId\n _CELONIS_TMP_gametransaction.balanceAfter_base\n _CELONIS_TMP_gametransaction.sportsbookWinnings_eur\n _CELONIS_TMP_gametransaction.availableBalanceAfterBonus\n _CELONIS_TMP_gametransaction.code\n _CELONIS_TMP_gametransaction.amountReal_eur\n _CELONIS_TMP_gametransaction.availableBalanceAfter_eur\n _CELONIS_TMP_gametransaction.gameId\n _CELONIS_TMP_gametransaction.syndicateSessionId\n _CELONIS_TMP_gametransaction.gameSessionId\n _CELONIS_TMP_gametransaction.amount_eur\n _CELONIS_TMP_gametransaction.providerRoundId\n _CELONIS_TMP_gametransaction.errorCode\n _CELONIS_TMP_gametransaction.availableBalanceAfterReal\n _CELONIS_TMP_gametransaction.betslipId\n _CELONIS_TMP_gametransaction.fxSpread\n _CELONIS_TMP_gametransaction.balanceAfter_eur\n _CELONIS_TMP_gametransaction.processedAt\n _CELONIS_TMP_gametransaction.providerBetslipId\n _CELONIS_TMP_gametransaction.betslipStatus\n _CELONIS_TMP_gametransaction.walletCurrencyCode\n _CELONIS_TMP_gametransaction.fxRate\n _CELONIS_TMP_gametransaction.providerAmount_base\n _CELONIS_TMP_gametransaction.sportsbookStatus\n _CELONIS_TMP_gametransaction.balanceAfterReal_eur\n _CELONIS_TMP_gametransaction.reason\n _CELONIS_TMP_gametransaction.jackpotContribution_eur\n _CELONIS_TMP_gametransaction.amountBonus\n _CELONIS_TMP_gametransaction.providerSportsbookId\n _CELONIS_TMP_gametransaction.providerAmount_eur\n _CELONIS_TMP_gametransaction.balanceAfter\n _CELONIS_TMP_gametransaction.details\n _CELONIS_TMP_gametransaction.createdAt\n _CELONIS_TMP_gametransaction.sportsbook\n _CELONIS_TMP_gametransaction.studio\n _CELONIS_TMP_gametransaction.amountBonus_eur\n _CELONIS_TMP_gametransaction.availableBalanceAfterBonus_base\n _CELONIS_TMP_gametransaction._CELONIS_INPUT_FILE\n _CELONIS_TMP_gametransaction.version\n _CELONIS_TMP_gametransaction.taxAmount_base\n _CELONIS_TMP_gametransaction.jackpotAmount_base\n _CELONIS_TMP_gametransaction.shopRef\n _CELONIS_TMP_gametransaction.taxAmount\n _CELONIS_TMP_gametransaction.jackpotAmount_eur\n _CELONIS_TMP_gametransaction.succeededAt\n _CELONIS_TMP_gametransaction.sportsbookWinnings\n _CELONIS_TMP_gametransaction.gameRoundIndex\n _CELONIS_TMP_gametransaction.terminalRef\n _CELONIS_TMP_gametransaction.amountBonus_base\n _CELONIS_TMP_gametransaction.userId\n _CELONIS_TMP_gametransaction.balanceAfterBonus\n _CELONIS_TMP_gametransaction.betslip\n _CELONIS_TMP_gametransaction.transactionReason\n _CELONIS_TMP_gametransaction.availableBalanceAfter_base\n _CELONIS_TMP_gametransaction.betslipWinnings_eur\n _CELONIS_TMP_gametransaction.availableBalanceAfterReal_eur\n _CELONIS_TMP_gametransaction.availableBalanceAfter\n _CELONIS_TMP_gametransaction.status\n _CELONIS_TMP_gametransaction.sessionId\n _CELONIS_TMP_gametransaction.amount_base\nUnc: Varchar(81)\nUnc: Integer(8)\nUnc: Varchar(81)\nUnc: Varchar(81)\nUnc: Float(8)\nUnc: Float(8)\nUnc: Varchar(81)\nUnc: Varchar(81)\nUnc: Varchar(81)\nUnc: Float(8)\nUnc: Boolean(1)\nUnc: Float(8)\nUnc: Varchar(81)\nUnc: Float(8)\nUnc: Float(8)\nUnc: Timestamp(8)\nUnc: Float(8)\nUnc: Varchar(81)\nUnc: Float(8)\nUnc: Float(8)\nUnc: Float(8)\nUnc: Float(8)\nUnc: Float(8)\nUnc: Float(8)\nUnc: Varchar(81)\nUnc: Float(8)\nUnc: Float(8)\nUnc: Boolean(1)\nUnc: Varchar(81)\nUnc: Float(8)\nUnc: Float(8)\nUnc: Float(8)\nUnc: Timestamp(8)\nUnc: Float(8)\nUnc: Float(8)\nUnc: Varchar(81)\nUnc: Varchar(81)\nUnc: Float(8)\nUnc: Float(8)\nUnc: Float(8)\nUnc: Varchar(81)\nUnc: Float(8)\nUnc: Float(8)\nUnc: Varchar(81)\nUnc: Varchar(81)\nUnc: Varchar(81)\nUnc: Float(8)\nUnc: Varchar(81)\nUnc: Varchar(81)\nUnc: Float(8)\nUnc: Varchar(81)\nUnc: Float(8)\nUnc: Float(8)\nUnc: Timestamp(8)\nUnc: Varchar(81)\nUnc: Varchar(81)\nUnc: Varchar(81)\nUnc: Float(8)\nUnc: Float(8)\nUnc: Varchar(81)\nUnc: Float(8)\nUnc: Varchar(81)\nUnc: Float(8)\nUnc: Float(8)\nUnc: Varchar(81)\nUnc: Float(8)\nUnc: Float(8)\nUnc: Varchar(81)\nUnc: Timestamp(8)\nUnc: Varchar(81)\nUnc: Varchar(81)\nUnc: Float(8)\nUnc: Float(8)\nUnc: Varchar(81)\nUnc: Integer(8)\nUnc: Float(8)\nUnc: Float(8)\nUnc: Varchar(81)\nUnc: Float(8)\nUnc: Float(8)\nUnc: Timestamp(8)\nUnc: Float(8)\nUnc: Integer(8)\nUnc: Varchar(81)\nUnc: Float(8)\nUnc: Varchar(81)\nUnc: Float(8)\nUnc: Varchar(81)\nUnc: Varchar(81)\nUnc: Float(8)\nUnc: Float(8)\nUnc: Float(8)\nUnc: Float(8)\nUnc: Varchar(81)\nUnc: Varchar(81)\nUnc: Float(8)"", color = ""green"", shape = ""box""];"
"17[label = ""StorageUnionStep: _CELONIS_TMP_gametransaction_super\nLocally Resegment\nUnc: Varchar(81)\nUnc: Varchar(81)\nUnc: Float(8)\nUnc: Float(8)\nUnc: Varchar(81)\nUnc: Varchar(81)\nUnc: Varchar(81)\nUnc: Float(8)\nUnc: Boolean(1)\nUnc: Float(8)\nUnc: Varchar(81)\nUnc: Float(8)\nUnc: Float(8)\nUnc: Timestamp(8)\nUnc: Float(8)\nUnc: Varchar(81)\nUnc: Float(8)\nUnc: Float(8)\nUnc: Float(8)\nUnc: Float(8)\nUnc: Float(8)\nUnc: Float(8)\nUnc: Varchar(81)\nUnc: Float(8)\nUnc: Float(8)\nUnc: Boolean(1)\nUnc: Varchar(81)\nUnc: Float(8)\nUnc: Float(8)\nUnc: Float(8)\nUnc: Timestamp(8)\nUnc: Float(8)\nUnc: Float(8)\nUnc: Varchar(81)\nUnc: Varchar(81)\nUnc: Float(8)\nUnc: Float(8)\nUnc: Float(8)\nUnc: Varchar(81)\nUnc: Float(8)\nUnc: Float(8)\nUnc: Varchar(81)\nUnc: Varchar(81)\nUnc: Varchar(81)\nUnc: Float(8)\nUnc: Varchar(81)\nUnc: Varchar(81)\nUnc: Float(8)\nUnc: Varchar(81)\nUnc: Float(8)\nUnc: Float(8)\nUnc: Timestamp(8)\nUnc: Varchar(81)\nUnc: Varchar(81)\nUnc: Varchar(81)\nUnc: Float(8)\nUnc: Varchar(81)\nUnc: Float(8)\nUnc: Varchar(81)\nUnc: Float(8)\nUnc: Varchar(81)\nUnc: Float(8)\nUnc: Float(8)\nUnc: Varchar(81)\nUnc: Float(8)\nUnc: Float(8)\nUnc: Varchar(81)\nUnc: Timestamp(8)\nUnc: Varchar(81)\nUnc: Varchar(81)\nUnc: Float(8)\nUnc: Float(8)\nUnc: Varchar(81)\nUnc: Integer(8)\nUnc: Float(8)\nUnc: Float(8)\nUnc: Varchar(81)\nUnc: Float(8)\nUnc: Float(8)\nUnc: Timestamp(8)\nUnc: Float(8)\nUnc: Integer(8)\nUnc: Varchar(81)\nUnc: Float(8)\nUnc: Varchar(81)\nUnc: Float(8)\nUnc: Varchar(81)\nUnc: Varchar(81)\nUnc: Float(8)\nUnc: Float(8)\nUnc: Float(8)\nUnc: Float(8)\nUnc: Varchar(81)\nUnc: Varchar(81)\nUnc: Float(8)"", color = ""purple"", shape = ""box""];"
"18[label = ""ScanStep: _CELONIS_TMP_gametransaction_super\ndevice\npromotionId\nproviderAmount\navailableBalanceAfterReal_base\nsportsbookId\namounts\ncurrencyCode\njackpotContribution\npromotional\namountReal_base\nproviderGameSessionId\nbetslipWinnings_base\nwalletAmount_eur\nbetslipSettledAt\njackpotAmount\nprovider\nbalanceAfterBonus_base\namountReal\nwalletAmount_base\nbalanceAfterBonus_eur\nbalanceAfterReal_base\nbetslipWinnings\ngameTransactionType\nwalletAmount\nbalanceAfterReal\ndiscardable\nmessage\namount\nsportsbookWinnings_base\njackpotContribution_base\nupdatedAt\navailableBalanceAfterBonus_eur\ntaxAmount_eur\ngameRoundId\nproviderGameTransactionId\nbalanceAfter_base\nsportsbookWinnings_eur\navailableBalanceAfterBonus\ncode\namountReal_eur\navailableBalanceAfter_eur\ngameId\nsyndicateSessionId\ngameSessionId\namount_eur\nproviderRoundId\nerrorCode\navailableBalanceAfterReal\nbetslipId\nfxSpread\nbalanceAfter_eur\nprocessedAt\nproviderBetslipId\nbetslipStatus\nwalletCurrencyCode\nfxRate\ngameTransactionId\nproviderAmount_base\nsportsbookStatus\nbalanceAfterReal_eur\nreason\njackpotContribution_eur\namountBonus\nproviderSportsbookId\nproviderAmount_eur\nbalanceAfter\ndetails\ncreatedAt\nsportsbook\nstudio\namountBonus_eur\navailableBalanceAfterBonus_base\n_CELONIS_INPUT_FILE\nversion\ntaxAmount_base\njackpotAmount_base\nshopRef\ntaxAmount\njackpotAmount_eur\nsucceededAt\nsportsbookWinnings\ngameRoundIndex\nterminalRef\namountBonus_base\nuserId\nbalanceAfterBonus\nbetslip\ntransactionReason\navailableBalanceAfter_base\nbetslipWinnings_eur\navailableBalanceAfterReal_eur\navailableBalanceAfter\nstatus\nsessionId\namount_base\nUnc: Varchar(81)\nUnc: Varchar(81)\nUnc: Float(8)\nUnc: Float(8)\nUnc: Varchar(81)\nUnc: Varchar(81)\nUnc: Varchar(81)\nUnc: Float(8)\nUnc: Boolean(1)\nUnc: Float(8)\nUnc: Varchar(81)\nUnc: Float(8)\nUnc: Float(8)\nUnc: Timestamp(8)\nUnc: Float(8)\nUnc: Varchar(81)\nUnc: Float(8)\nUnc: Float(8)\nUnc: Float(8)\nUnc: Float(8)\nUnc: Float(8)\nUnc: Float(8)\nUnc: Varchar(81)\nUnc: Float(8)\nUnc: Float(8)\nUnc: Boolean(1)\nUnc: Varchar(81)\nUnc: Float(8)\nUnc: Float(8)\nUnc: Float(8)\nUnc: Timestamp(8)\nUnc: Float(8)\nUnc: Float(8)\nUnc: Varchar(81)\nUnc: Varchar(81)\nUnc: Float(8)\nUnc: Float(8)\nUnc: Float(8)\nUnc: Varchar(81)\nUnc: Float(8)\nUnc: Float(8)\nUnc: Varchar(81)\nUnc: Varchar(81)\nUnc: Varchar(81)\nUnc: Float(8)\nUnc: Varchar(81)\nUnc: Varchar(81)\nUnc: Float(8)\nUnc: Varchar(81)\nUnc: Float(8)\nUnc: Float(8)\nUnc: Timestamp(8)\nUnc: Varchar(81)\nUnc: Varchar(81)\nUnc: Varchar(81)\nUnc: Float(8)\nUnc: Varchar(81)\nUnc: Float(8)\nUnc: Varchar(81)\nUnc: Float(8)\nUnc: Varchar(81)\nUnc: Float(8)\nUnc: Float(8)\nUnc: Varchar(81)\nUnc: Float(8)\nUnc: Float(8)\nUnc: Varchar(81)\nUnc: Timestamp(8)\nUnc: Varchar(81)\nUnc: Varchar(81)\nUnc: Float(8)\nUnc: Float(8)\nUnc: Varchar(81)\nUnc: Integer(8)\nUnc: Float(8)\nUnc: Float(8)\nUnc: Varchar(81)\nUnc: Float(8)\nUnc: Float(8)\nUnc: Timestamp(8)\nUnc: Float(8)\nUnc: Integer(8)\nUnc: Varchar(81)\nUnc: Float(8)\nUnc: Varchar(81)\nUnc: Float(8)\nUnc: Varchar(81)\nUnc: Varchar(81)\nUnc: Float(8)\nUnc: Float(8)\nUnc: Float(8)\nUnc: Float(8)\nUnc: Varchar(81)\nUnc: Varchar(81)\nUnc: Float(8)"", color = ""brown"", shape = ""box""];"
"19[label = ""Copy \nOutBlk=[UncTuple(195)]"", color = ""green"", shape = ""ellipse""];"
"20[label = ""Copy \nOutBlk=[UncTuple(195)]"", color = ""green"", shape = ""ellipse""];"
"21[label = ""Copy \nOutBlk=[UncTuple(195)]"", color = ""green"", shape = ""ellipse""];"
"22[label = ""Copy \nOutBlk=[UncTuple(195)]"", color = ""green"", shape = ""ellipse""];"
"23[label = ""Copy \nOutBlk=[UncTuple(195)]"", color = ""green"", shape = ""ellipse""];"
"24[label = ""Copy \nOutBlk=[UncTuple(195)]"", color = ""green"", shape = ""ellipse""];"
"25[label = ""Copy \nOutBlk=[UncTuple(195)]"", color = ""green"", shape = ""ellipse""];"
"26[label = ""Copy \nOutBlk=[UncTuple(195)]"", color = ""green"", shape = ""ellipse""];"
"27[label = ""Copy \nOutBlk=[UncTuple(195)]"", color = ""green"", shape = ""ellipse""];"
"28[label = ""Copy \nOutBlk=[UncTuple(195)]"", color = ""green"", shape = ""ellipse""];"
"29[label = ""Copy \nOutBlk=[UncTuple(195)]"", color = ""green"", shape = ""ellipse""];"
"30[label = ""Copy \nOutBlk=[UncTuple(195)]"", color = ""green"", shape = ""ellipse""];"
"31[label = ""Copy \nOutBlk=[UncTuple(195)]"", color = ""green"", shape = ""ellipse""];"
"32[label = ""Copy \nOutBlk=[UncTuple(195)]"", color = ""green"", shape = ""ellipse""];"
"33[label = ""Copy \nOutBlk=[UncTuple(195)]"", color = ""green"", shape = ""ellipse""];"
"34[label = ""Copy \nOutBlk=[UncTuple(195)]"", color = ""green"", shape = ""ellipse""];"
"35[label = ""Copy \nOutBlk=[UncTuple(195)]"", color = ""green"", shape = ""ellipse""];"
"36[label = ""Copy \nOutBlk=[UncTuple(195)]"", color = ""green"", shape = ""ellipse""];"
"37[label = ""Copy \nOutBlk=[UncTuple(195)]"", color = ""green"", shape = ""ellipse""];"
"38[label = ""Copy \nOutBlk=[UncTuple(195)]"", color = ""green"", shape = ""ellipse""];"
"39[label = ""Copy \nOutBlk=[UncTuple(195)]"", color = ""green"", shape = ""ellipse""];"
"40[label = ""Copy \nOutBlk=[UncTuple(195)]"", color = ""green"", shape = ""ellipse""];"
"41[label = ""Copy \nOutBlk=[UncTuple(195)]"", color = ""green"", shape = ""ellipse""];"
"42[label = ""Copy \nOutBlk=[UncTuple(195)]"", color = ""green"", shape = ""ellipse""];"
"43[label = ""Copy \nOutBlk=[UncTuple(195)]"", color = ""green"", shape = ""ellipse""];"
"44[label = ""Copy \nOutBlk=[UncTuple(195)]"", color = ""green"", shape = ""ellipse""];"
"45[label = ""Copy \nOutBlk=[UncTuple(195)]"", color = ""green"", shape = ""ellipse""];"
"46[label = ""Copy \nOutBlk=[UncTuple(195)]"", color = ""green"", shape = ""ellipse""];"
"47[label = ""Copy \nOutBlk=[UncTuple(195)]"", color = ""green"", shape = ""ellipse""];"
"48[label = ""Copy \nOutBlk=[UncTuple(195)]"", color = ""green"", shape = ""ellipse""];"
"49[label = ""Copy \nOutBlk=[UncTuple(195)]"", color = ""green"", shape = ""ellipse""];"
"50[label = ""Copy \nOutBlk=[UncTuple(195)]"", color = ""green"", shape = ""ellipse""];"
"51[label = ""Copy \nOutBlk=[UncTuple(195)]"", color = ""green"", shape = ""ellipse""];"
"52[label = ""Copy \nOutBlk=[UncTuple(195)]"", color = ""green"", shape = ""ellipse""];"
"53[label = ""Copy \nOutBlk=[UncTuple(195)]"", color = ""green"", shape = ""ellipse""];"
"54[label = ""Copy \nOutBlk=[UncTuple(195)]"", color = ""green"", shape = ""ellipse""];"
"55[label = ""Copy \nOutBlk=[UncTuple(195)]"", color = ""green"", shape = ""ellipse""];"
"56[label = ""Copy \nOutBlk=[UncTuple(195)]"", color = ""green"", shape = ""ellipse""];"
"57[label = ""Copy \nOutBlk=[UncTuple(195)]"", color = ""green"", shape = ""ellipse""];"
"58[label = ""Copy \nOutBlk=[UncTuple(195)]"", color = ""green"", shape = ""ellipse""];"
"59[label = ""Copy \nOutBlk=[UncTuple(195)]"", color = ""green"", shape = ""ellipse""];"
"60[label = ""Copy \nOutBlk=[UncTuple(195)]"", color = ""green"", shape = ""ellipse""];"
"61[label = ""Copy \nOutBlk=[UncTuple(195)]"", color = ""green"", shape = ""ellipse""];"
"62[label = ""Copy \nOutBlk=[UncTuple(195)]"", color = ""green"", shape = ""ellipse""];"
"63[label = ""Copy \nOutBlk=[UncTuple(195)]"", color = ""green"", shape = ""ellipse""];"
"64[label = ""Copy \nOutBlk=[UncTuple(195)]"", color = ""green"", shape = ""ellipse""];"
"65[label = ""Copy \nOutBlk=[UncTuple(195)]"", color = ""green"", shape = ""ellipse""];"
"66[label = ""Copy \nOutBlk=[UncTuple(195)]"", color = ""green"", shape = ""ellipse""];"
"67[label = ""Copy \nOutBlk=[UncTuple(195)]"", color = ""green"", shape = ""ellipse""];"
"68[label = ""Copy \nOutBlk=[UncTuple(195)]"", color = ""green"", shape = ""ellipse""];"
"69[label = ""Copy \nOutBlk=[UncTuple(195)]"", color = ""green"", shape = ""ellipse""];"
"70[label = ""Copy \nOutBlk=[UncTuple(195)]"", color = ""green"", shape = ""ellipse""];"
"71[label = ""Copy \nOutBlk=[UncTuple(195)]"", color = ""green"", shape = ""ellipse""];"
"72[label = ""Copy \nOutBlk=[UncTuple(195)]"", color = ""green"", shape = ""ellipse""];"
"73[label = ""Copy \nOutBlk=[UncTuple(195)]"", color = ""green"", shape = ""ellipse""];"
"74[label = ""Copy \nOutBlk=[UncTuple(195)]"", color = ""green"", shape = ""ellipse""];"
"75[label = ""Copy \nOutBlk=[UncTuple(195)]"", color = ""green"", shape = ""ellipse""];"
"76[label = ""Copy \nOutBlk=[UncTuple(195)]"", color = ""green"", shape = ""ellipse""];"
"77[label = ""Copy \nOutBlk=[UncTuple(195)]"", color = ""green"", shape = ""ellipse""];"
"78[label = ""Copy \nOutBlk=[UncTuple(195)]"", color = ""green"", shape = ""ellipse""];"
"79[label = ""Copy \nOutBlk=[UncTuple(195)]"", color = ""green"", shape = ""ellipse""];"
"80[label = ""Copy \nOutBlk=[UncTuple(195)]"", color = ""green"", shape = ""ellipse""];"
"81[label = ""Copy \nOutBlk=[UncTuple(195)]"", color = ""green"", shape = ""ellipse""];"
"82[label = ""Copy \nOutBlk=[UncTuple(195)]"", color = ""green"", shape = ""ellipse""];"
"83[label = ""Copy \nOutBlk=[UncTuple(195)]"", color = ""green"", shape = ""ellipse""];"
"84[label = ""Copy \nOutBlk=[UncTuple(195)]"", color = ""green"", shape = ""ellipse""];"
"85[label = ""Copy \nOutBlk=[UncTuple(195)]"", color = ""green"", shape = ""ellipse""];"
"86[label = ""Copy \nOutBlk=[UncTuple(195)]"", color = ""green"", shape = ""ellipse""];"
"87[label = ""Copy \nOutBlk=[UncTuple(195)]"", color = ""green"", shape = ""ellipse""];"
"88[label = ""Copy \nOutBlk=[UncTuple(195)]"", color = ""green"", shape = ""ellipse""];"
"89[label = ""Copy \nOutBlk=[UncTuple(195)]"", color = ""green"", shape = ""ellipse""];"
"90[label = ""Copy \nOutBlk=[UncTuple(195)]"", color = ""green"", shape = ""ellipse""];"
"91[label = ""Copy \nOutBlk=[UncTuple(195)]"", color = ""green"", shape = ""ellipse""];"
"92[label = ""Copy \nOutBlk=[UncTuple(195)]"", color = ""green"", shape = ""ellipse""];"
"93[label = ""Copy \nOutBlk=[UncTuple(195)]"", color = ""green"", shape = ""ellipse""];"
"94[label = ""Copy \nOutBlk=[UncTuple(195)]"", color = ""green"", shape = ""ellipse""];"
"95[label = ""Copy \nOutBlk=[UncTuple(195)]"", color = ""green"", shape = ""ellipse""];"
"96[label = ""Copy \nOutBlk=[UncTuple(195)]"", color = ""green"", shape = ""ellipse""];"
"97[label = ""Copy \nOutBlk=[UncTuple(195)]"", color = ""green"", shape = ""ellipse""];"
"98[label = ""Copy \nOutBlk=[UncTuple(195)]"", color = ""green"", shape = ""ellipse""];"
"99[label = ""Copy \nOutBlk=[UncTuple(195)]"", color = ""green"", shape = ""ellipse""];"
"100[label = ""Copy \nOutBlk=[UncTuple(195)]"", color = ""green"", shape = ""ellipse""];"
"101[label = ""Copy \nOutBlk=[UncTuple(195)]"", color = ""green"", shape = ""ellipse""];"
"102[label = ""Copy \nOutBlk=[UncTuple(195)]"", color = ""green"", shape = ""ellipse""];"
"103[label = ""Copy \nOutBlk=[UncTuple(195)]"", color = ""green"", shape = ""ellipse""];"
"104[label = ""Copy \nOutBlk=[UncTuple(195)]"", color = ""green"", shape = ""ellipse""];"
"105[label = ""Copy \nOutBlk=[UncTuple(195)]"", color = ""green"", shape = ""ellipse""];"
"106[label = ""Copy \nOutBlk=[UncTuple(195)]"", color = ""green"", shape = ""ellipse""];"
"107[label = ""Copy \nOutBlk=[UncTuple(195)]"", color = ""green"", shape = ""ellipse""];"
"108[label = ""Copy \nOutBlk=[UncTuple(195)]"", color = ""green"", shape = ""ellipse""];"
"109[label = ""Copy \nOutBlk=[UncTuple(195)]"", color = ""green"", shape = ""ellipse""];"
"110[label = ""Copy \nOutBlk=[UncTuple(195)]"", color = ""green"", shape = ""ellipse""];"
"111[label = ""Copy \nOutBlk=[UncTuple(195)]"", color = ""green"", shape = ""ellipse""];"
"112[label = ""Copy \nOutBlk=[UncTuple(195)]"", color = ""green"", shape = ""ellipse""];"
"113[label = ""Copy \nOutBlk=[UncTuple(195)]"", color = ""green"", shape = ""ellipse""];"
"114[label = ""Copy \nOutBlk=[UncTuple(195)]"", color = ""green"", shape = ""ellipse""];"
"115[label = ""Copy \nOutBlk=[UncTuple(195)]"", color = ""green"", shape = ""ellipse""];"
"116[label = ""Copy \nOutBlk=[UncTuple(195)]"", color = ""green"", shape = ""ellipse""];"
"117[label = ""Copy \nOutBlk=[UncTuple(195)]"", color = ""green"", shape = ""ellipse""];"
"118[label = ""Copy \nOutBlk=[UncTuple(195)]"", color = ""green"", shape = ""ellipse""];"
"119[label = ""DT(DIRECT)[gametransaction_super]\n+Sort (keys = Ax8,Nx89) \nOutBlk=[UncTuple]"", color = ""blue"", shape = ""ellipse""];"
"120[label = ""Delete-gametransaction_super \nOutBlk=[UncTuple(2)]"", color = ""green"", shape = ""ellipse""];"
"121[label = ""Segment() \nOutBlk=[UncTuple(97)]"", color = ""green"", shape = ""ellipse""];"
"122[label = ""Filter\n \nOutBlk=[UncTuple(98)]"", color = ""green"", shape = ""ellipse""];"
"123[label = ""Sort (keys = Ax8,Nx89) \nOutBlk=[UncTuple(97)-PasV]"", color = ""green"", shape = ""box""];"
"124[label = ""DIST-Union (#cols = 97,#strms = 1) \nOutBlk=[UncTuple(97)]"", color = ""green"", shape = ""ellipse""];"
"125[label = ""ValExpNode \nOutBlk=[UncTuple(3)]"", color = ""red"", shape = ""ellipse""];"
"126[label = ""DVDT(DIRECTCOLS)[gametransaction_super]\n+Sort (keys = A,N) \nOutBlk=[UncTuple]"", color = ""blue"", shape = ""ellipse""];"
"127[label = ""Segment() \nOutBlk=[UncTuple(97)]"", color = ""green"", shape = ""ellipse""];"
"128[label = ""ValExpNode \nOutBlk=[UncTuple(97)]"", color = ""green"", shape = ""ellipse""];"
"129[label = ""ValExpNode \nOutBlk=[UncTuple(97)]"", color = ""green"", shape = ""ellipse""];"
"130[label = ""Filter\n \nOutBlk=[UncTuple(195)]"", color = ""green"", shape = ""ellipse""];"
"131[label = ""DIST-Union (#cols = 97,#strms = 1) \nOutBlk=[UncTuple(97)]"", color = ""green"", shape = ""ellipse""];"
"132[label = ""DT(DIRECT)[gametransaction_PK]\n+Sort (keys = A,N) \nOutBlk=[UncTuple]"", color = ""blue"", shape = ""ellipse""];"
"133[label = ""Delete-gametransaction_PK \nOutBlk=[UncTuple(2)]"", color = ""green"", shape = ""ellipse""];"
"134[label = ""Segment() \nOutBlk=[UncTuple(2)]"", color = ""green"", shape = ""ellipse""];"
"135[label = ""Filter\n \nOutBlk=[UncTuple(3)]"", color = ""green"", shape = ""ellipse""];"
"136[label = ""Sort (keys = A,N) \nOutBlk=[UncTuple(2)-PasV]"", color = ""green"", shape = ""box""];"
"137[label = ""DIST-Union (#cols = 2,#strms = 1) \nOutBlk=[UncTuple(2)]"", color = ""green"", shape = ""ellipse""];"
"138[label = ""ValExpNode \nOutBlk=[UncTuple(3)]"", color = ""red"", shape = ""ellipse""];"
"139[label = ""DVDT(DIRECTCOLS)[gametransaction_PK]\n+Sort (keys = A,N) \nOutBlk=[UncTuple]"", color = ""blue"", shape = ""ellipse""];"
"140[label = ""Segment() \nOutBlk=[UncTuple(2)]"", color = ""green"", shape = ""ellipse""];"
"141[label = ""ValExpNode \nOutBlk=[UncTuple(2)]"", color = ""green"", shape = ""ellipse""];"
"142[label = ""ValExpNode \nOutBlk=[UncTuple(2)]"", color = ""green"", shape = ""ellipse""];"
"143[label = ""Filter\n \nOutBlk=[UncTuple(5)]"", color = ""green"", shape = ""ellipse""];"
"144[label = ""DIST-Union (#cols = 2,#strms = 1) \nOutBlk=[UncTuple(2)]"", color = ""green"", shape = ""ellipse""];"
"145[label = ""Basic-Union (#cols = 1,#strms = 4) \nOutBlk=[UncTuple]"", color = ""green"", shape = ""ellipse""];"
"146[label = ""GroupBy(NOTHING) \nOutBlk=[UncTuple]"", color = ""green"", shape = ""box""];"
"1->19 [label = ""V[0]"",color = ""black""];"
"1->20 [label = ""V[0]"",color = ""black""];"
"1->21 [label = ""V[0]"",color = ""black""];"
"1->22 [label = ""V[0]"",color = ""black""];"
"1->23 [label = ""V[0]"",color = ""black""];"
"1->24 [label = ""V[0]"",color = ""black""];"
"1->25 [label = ""V[0]"",color = ""black""];"
"1->26 [label = ""V[0]"",color = ""black""];"
"1->27 [label = ""V[0]"",color = ""black""];"
"1->28 [label = ""V[0]"",color = ""black""];"
"1->29 [label = ""V[0]"",color = ""black""];"
"1->30 [label = ""V[0]"",color = ""black""];"
"1->31 [label = ""V[0]"",color = ""black""];"
"1->32 [label = ""V[0]"",color = ""black""];"
"1->33 [label = ""V[0]"",color = ""black""];"
"1->34 [label = ""V[0]"",color = ""black""];"
"1->35 [label = ""V[0]"",color = ""black""];"
"1->36 [label = ""V[0]"",color = ""black""];"
"1->37 [label = ""V[0]"",color = ""black""];"
"1->38 [label = ""V[0]"",color = ""black""];"
"1->39 [label = ""V[0]"",color = ""black""];"
"1->40 [label = ""V[0]"",color = ""black""];"
"1->41 [label = ""V[0]"",color = ""black""];"
"1->42 [label = ""V[0]"",color = ""black""];"
"1->43 [label = ""V[0]"",color = ""black""];"
"1->44 [label = ""V[0]"",color = ""black""];"
"1->45 [label = ""V[0]"",color = ""black""];"
"1->46 [label = ""V[0]"",color = ""black""];"
"1->47 [label = ""V[0]"",color = ""black""];"
"1->48 [label = ""V[0]"",color = ""black""];"
"1->49 [label = ""V[0]"",color = ""black""];"
"1->50 [label = ""V[0]"",color = ""black""];"
"1->51 [label = ""V[0]"",color = ""black""];"
"1->52 [label = ""V[0]"",color = ""black""];"
"1->53 [label = ""V[0]"",color = ""black""];"
"1->54 [label = ""V[0]"",color = ""black""];"
"1->55 [label = ""V[0]"",color = ""black""];"
"1->56 [label = ""V[0]"",color = ""black""];"
"1->57 [label = ""V[0]"",color = ""black""];"
"1->58 [label = ""V[0]"",color = ""black""];"
"1->59 [label = ""V[0]"",color = ""black""];"
"1->60 [label = ""V[0]"",color = ""black""];"
"1->61 [label = ""V[0]"",color = ""black""];"
"1->62 [label = ""V[0]"",color = ""black""];"
"1->63 [label = ""V[0]"",color = ""black""];"
"1->64 [label = ""V[0]"",color = ""black""];"
"1->65 [label = ""V[0]"",color = ""black""];"
"1->66 [label = ""V[0]"",color = ""black""];"
"1->67 [label = ""V[0]"",color = ""black""];"
"1->68 [label = ""V[0]"",color = ""black""];"
"1->69 [label = ""V[0]"",color = ""black""];"
"1->70 [label = ""V[0]"",color = ""black""];"
"1->71 [label = ""V[0]"",color = ""black""];"
"1->72 [label = ""V[0]"",color = ""black""];"
"1->73 [label = ""V[0]"",color = ""black""];"
"1->74 [label = ""V[0]"",color = ""black""];"
"1->75 [label = ""V[0]"",color = ""black""];"
"1->76 [label = ""V[0]"",color = ""black""];"
"1->77 [label = ""V[0]"",color = ""black""];"
"1->78 [label = ""V[0]"",color = ""black""];"
"1->79 [label = ""V[0]"",color = ""black""];"
"1->80 [label = ""V[0]"",color = ""black""];"
"1->81 [label = ""V[0]"",color = ""black""];"
"1->82 [label = ""V[0]"",color = ""black""];"
"1->83 [label = ""V[0]"",color = ""black""];"
"1->84 [label = ""V[0]"",color = ""black""];"
"1->85 [label = ""V[0]"",color = ""black""];"
"1->86 [label = ""V[0]"",color = ""black""];"
"1->87 [label = ""V[0]"",color = ""black""];"
"1->88 [label = ""V[0]"",color = ""black""];"
"1->89 [label = ""V[0]"",color = ""black""];"
"1->90 [label = ""V[0]"",color = ""black""];"
"1->91 [label = ""V[0]"",color = ""black""];"
"1->92 [label = ""V[0]"",color = ""black""];"
"1->93 [label = ""V[0]"",color = ""black""];"
"1->94 [label = ""V[0]"",color = ""black""];"
"1->95 [label = ""V[0]"",color = ""black""];"
"1->96 [label = ""V[0]"",color = ""black""];"
"1->97 [label = ""V[0]"",color = ""black""];"
"1->98 [label = ""V[0]"",color = ""black""];"
"1->99 [label = ""V[0]"",color = ""black""];"
"1->100 [label = ""V[0]"",color = ""black""];"
"1->101 [label = ""V[0]"",color = ""black""];"
"1->102 [label = ""V[0]"",color = ""black""];"
"1->103 [label = ""V[0]"",color = ""black""];"
"1->104 [label = ""V[0]"",color = ""black""];"
"1->105 [label = ""V[0]"",color = ""black""];"
"1->106 [label = ""V[0]"",color = ""black""];"
"1->107 [label = ""V[0]"",color = ""black""];"
"1->108 [label = ""V[0]"",color = ""black""];"
"1->109 [label = ""V[0]"",color = ""black""];"
"1->110 [label = ""V[0]"",color = ""black""];"
"1->111 [label = ""V[0]"",color = ""black""];"
"1->112 [label = ""V[0]"",color = ""black""];"
"1->113 [label = ""V[0]"",color = ""black""];"
"1->114 [label = ""V[0]"",color = ""black""];"
"1->115 [label = ""V[0]"",color = ""black""];"
"1->130 [label = ""V[0] C=95"",color = ""black"",style=""bold"", arrowtail=""inv""];"
"1->116 [label = ""V[0]"",color = ""black""];"
"1->117 [label = ""V[0]"",color = ""black""];"
"1->118 [label = ""V[0]"",color = ""black""];"
"2->1 [label = ""0"",color = ""blue""];"
"3->2 [label = ""0"",color = ""blue""];"
"4->3 [label = ""0"",color = ""blue""];"
"5->4 [label = ""0"",color = ""blue""];"
"6->5 [label = ""0"",color = ""blue""];"
"7->6 [label = ""0"",color = ""blue""];"
"8->5 [label = ""1"",color = ""blue""];"
"9->8 [label = ""0"",color = ""blue""];"
"10->9 [label = ""0"",color = ""blue""];"
"11->10 [label = ""0"",color = ""blue""];"
"12->11 [label = ""0"",color = ""blue""];"
"13->12 [label = ""0"",color = ""blue""];"
"14->13 [label = ""0"",color = ""blue""];"
"15->14 [label = ""0"",color = ""blue""];"
"16->15 [label = ""0"",color = ""blue""];"
"17->16 [label = ""0"",color = ""blue""];"
"18->17 [label = ""0"",color = ""blue""];"
"19->122 [label = ""V[0]"",color = ""black""];"
"19->130 [label = ""V[0]"",color = ""black""];"
"20->122 [label = ""V[0]"",color = ""black""];"
"20->130 [label = ""V[0]"",color = ""black""];"
"20->135 [label = ""V[0]"",color = ""black""];"
"20->143 [label = ""V[0]"",color = ""black""];"
"21->122 [label = ""V[0]"",color = ""black""];"
"21->130 [label = ""V[0]"",color = ""black""];"
"22->122 [label = ""V[0]"",color = ""black""];"
"22->130 [label = ""V[0]"",color = ""black""];"
"23->122 [label = ""V[0]"",color = ""black""];"
"23->130 [label = ""V[0]"",color = ""black""];"
"24->122 [label = ""V[0]"",color = ""black""];"
"24->130 [label = ""V[0]"",color = ""black""];"
"25->122 [label = ""V[0]"",color = ""black""];"
"25->130 [label = ""V[0]"",color = ""black""];"
"26->122 [label = ""V[0]"",color = ""black""];"
"26->130 [label = ""V[0]"",color = ""black""];"
"27->122 [label = ""V[0]"",color = ""black""];"
"27->130 [label = ""V[0]"",color = ""black""];"
"28->122 [label = ""V[0]"",color = ""black""];"
"28->130 [label = ""V[0]"",color = ""black""];"
"29->122 [label = ""V[0]"",color = ""black""];"
"29->130 [label = ""V[0]"",color = ""black""];"
"30->122 [label = ""V[0]"",color = ""black""];"
"30->130 [label = ""V[0]"",color = ""black""];"
"31->122 [label = ""V[0]"",color = ""black""];"
"31->130 [label = ""V[0]"",color = ""black""];"
"32->122 [label = ""V[0]"",color = ""black""];"
"32->130 [label = ""V[0]"",color = ""black""];"
"33->122 [label = ""V[0]"",color = ""black""];"
"33->130 [label = ""V[0]"",color = ""black""];"
"34->122 [label = ""V[0]"",color = ""black""];"
"34->130 [label = ""V[0]"",color = ""black""];"
"35->122 [label = ""V[0]"",color = ""black""];"
"35->130 [label = ""V[0]"",color = ""black""];"
"36->122 [label = ""V[0]"",color = ""black""];"
"36->130 [label = ""V[0]"",color = ""black""];"
"37->122 [label = ""V[0]"",color = ""black""];"
"37->130 [label = ""V[0]"",color = ""black""];"
"38->122 [label = ""V[0]"",color = ""black""];"
"38->130 [label = ""V[0]"",color = ""black""];"
"39->122 [label = ""V[0]"",color = ""black""];"
"39->130 [label = ""V[0]"",color = ""black""];"
"40->122 [label = ""V[0]"",color = ""black""];"
"40->130 [label = ""V[0]"",color = ""black""];"
"41->122 [label = ""V[0]"",color = ""black""];"
"41->130 [label = ""V[0]"",color = ""black""];"
"42->122 [label = ""V[0]"",color = ""black""];"
"42->130 [label = ""V[0]"",color = ""black""];"
"43->122 [label = ""V[0]"",color = ""black""];"
"43->130 [label = ""V[0]"",color = ""black""];"
"44->122 [label = ""V[0]"",color = ""black""];"
"44->130 [label = ""V[0]"",color = ""black""];"
"45->122 [label = ""V[0]"",color = ""black""];"
"45->130 [label = ""V[0]"",color = ""black""];"
"46->122 [label = ""V[0]"",color = ""black""];"
"46->130 [label = ""V[0]"",color = ""black""];"
"47->122 [label = ""V[0]"",color = ""black""];"
"47->130 [label = ""V[0]"",color = ""black""];"
"48->122 [label = ""V[0]"",color = ""black""];"
"48->130 [label = ""V[0]"",color = ""black""];"
"49->122 [label = ""V[0]"",color = ""black""];"
"49->130 [label = ""V[0]"",color = ""black""];"
"50->122 [label = ""V[0]"",color = ""black""];"
"50->130 [label = ""V[0]"",color = ""black""];"
"51->122 [label = ""V[0]"",color = ""black""];"
"51->130 [label = ""V[0]"",color = ""black""];"
"52->122 [label = ""V[0]"",color = ""black""];"
"52->130 [label = ""V[0]"",color = ""black""];"
"53->122 [label = ""V[0]"",color = ""black""];"
"53->130 [label = ""V[0]"",color = ""black""];"
"54->122 [label = ""V[0]"",color = ""black""];"
"54->130 [label = ""V[0]"",color = ""black""];"
"55->122 [label = ""V[0]"",color = ""black""];"
"55->130 [label = ""V[0]"",color = ""black""];"
"56->122 [label = ""V[0]"",color = ""black""];"
"56->130 [label = ""V[0]"",color = ""black""];"
"57->122 [label = ""V[0]"",color = ""black""];"
"57->130 [label = ""V[0]"",color = ""black""];"
"58->122 [label = ""V[0]"",color = ""black""];"
"58->130 [label = ""V[0]"",color = ""black""];"
"59->122 [label = ""V[0]"",color = ""black""];"
"59->130 [label = ""V[0]"",color = ""black""];"
"60->122 [label = ""V[0]"",color = ""black""];"
"60->130 [label = ""V[0]"",color = ""black""];"
"61->122 [label = ""V[0]"",color = ""black""];"
"61->130 [label = ""V[0]"",color = ""black""];"
"62->122 [label = ""V[0]"",color = ""black""];"
"62->130 [label = ""V[0]"",color = ""black""];"
"63->122 [label = ""V[0]"",color = ""black""];"
"63->130 [label = ""V[0]"",color = ""black""];"
"64->122 [label = ""V[0]"",color = ""black""];"
"64->130 [label = ""V[0]"",color = ""black""];"
"65->122 [label = ""V[0]"",color = ""black""];"
"65->130 [label = ""V[0]"",color = ""black""];"
"66->122 [label = ""V[0]"",color = ""black""];"
"66->130 [label = ""V[0]"",color = ""black""];"
"67->122 [label = ""V[0]"",color = ""black""];"
"67->130 [label = ""V[0]"",color = ""black""];"
"68->122 [label = ""V[0]"",color = ""black""];"
"68->130 [label = ""V[0]"",color = ""black""];"
"69->122 [label = ""V[0]"",color = ""black""];"
"69->130 [label = ""V[0]"",color = ""black""];"
"70->122 [label = ""V[0]"",color = ""black""];"
"70->130 [label = ""V[0]"",color = ""black""];"
"71->122 [label = ""V[0]"",color = ""black""];"
"71->130 [label = ""V[0]"",color = ""black""];"
"72->122 [label = ""V[0]"",color = ""black""];"
"72->130 [label = ""V[0]"",color = ""black""];"
"73->122 [label = ""V[0]"",color = ""black""];"
"73->130 [label = ""V[0]"",color = ""black""];"
"74->122 [label = ""V[0]"",color = ""black""];"
"74->130 [label = ""V[0]"",color = ""black""];"
"75->122 [label = ""V[0]"",color = ""black""];"
"75->130 [label = ""V[0]"",color = ""black""];"
"76->122 [label = ""V[0]"",color = ""black""];"
"76->130 [label = ""V[0]"",color = ""black""];"
"77->122 [label = ""V[0]"",color = ""black""];"
"77->130 [label = ""V[0]"",color = ""black""];"
"78->122 [label = ""V[0]"",color = ""black""];"
"78->130 [label = ""V[0]"",color = ""black""];"
"79->122 [label = ""V[0]"",color = ""black""];"
"79->130 [label = ""V[0]"",color = ""black""];"
"80->122 [label = ""V[0]"",color = ""black""];"
"80->130 [label = ""V[0]"",color = ""black""];"
"81->122 [label = ""V[0]"",color = ""black""];"
"81->130 [label = ""V[0]"",color = ""black""];"
"82->122 [label = ""V[0]"",color = ""black""];"
"82->130 [label = ""V[0]"",color = ""black""];"
"83->122 [label = ""V[0]"",color = ""black""];"
"83->130 [label = ""V[0]"",color = ""black""];"
"84->122 [label = ""V[0]"",color = ""black""];"
"84->130 [label = ""V[0]"",color = ""black""];"
"85->122 [label = ""V[0]"",color = ""black""];"
"85->130 [label = ""V[0]"",color = ""black""];"
"86->122 [label = ""V[0]"",color = ""black""];"
"86->130 [label = ""V[0]"",color = ""black""];"
"87->122 [label = ""V[0]"",color = ""black""];"
"87->130 [label = ""V[0]"",color = ""black""];"
"88->122 [label = ""V[0]"",color = ""black""];"
"88->130 [label = ""V[0]"",color = ""black""];"
"89->122 [label = ""V[0]"",color = ""black""];"
"89->130 [label = ""V[0]"",color = ""black""];"
"90->122 [label = ""V[0]"",color = ""black""];"
"90->130 [label = ""V[0]"",color = ""black""];"
"91->122 [label = ""V[0]"",color = ""black""];"
"91->130 [label = ""V[0]"",color = ""black""];"
"92->122 [label = ""V[0]"",color = ""black""];"
"92->130 [label = ""V[0]"",color = ""black""];"
"93->122 [label = ""V[0]"",color = ""black""];"
"93->130 [label = ""V[0]"",color = ""black""];"
"94->122 [label = ""V[0]"",color = ""black""];"
"94->130 [label = ""V[0]"",color = ""black""];"
"95->122 [label = ""V[0]"",color = ""black""];"
"95->130 [label = ""V[0]"",color = ""black""];"
"96->122 [label = ""V[0]"",color = ""black""];"
"96->130 [label = ""V[0]"",color = ""black""];"
"97->122 [label = ""V[0]"",color = ""black""];"
"97->130 [label = ""V[0]"",color = ""black""];"
"98->122 [label = ""V[0]"",color = ""black""];"
"98->130 [label = ""V[0]"",color = ""black""];"
"99->122 [label = ""V[0]"",color = ""black""];"
"99->130 [label = ""V[0]"",color = ""black""];"
"100->122 [label = ""V[0]"",color = ""black""];"
"100->130 [label = ""V[0]"",color = ""black""];"
"101->122 [label = ""V[0]"",color = ""black""];"
"101->130 [label = ""V[0]"",color = ""black""];"
"102->122 [label = ""V[0]"",color = ""black""];"
"102->130 [label = ""V[0]"",color = ""black""];"
"103->122 [label = ""V[0]"",color = ""black""];"
"103->130 [label = ""V[0]"",color = ""black""];"
"104->122 [label = ""V[0]"",color = ""black""];"
"104->130 [label = ""V[0]"",color = ""black""];"
"105->122 [label = ""V[0]"",color = ""black""];"
"105->130 [label = ""V[0]"",color = ""black""];"
"106->122 [label = ""V[0]"",color = ""black""];"
"106->130 [label = ""V[0]"",color = ""black""];"
"107->122 [label = ""V[0]"",color = ""black""];"
"107->130 [label = ""V[0]"",color = ""black""];"
"108->122 [label = ""V[0]"",color = ""black""];"
"108->130 [label = ""V[0]"",color = ""black""];"
"109->122 [label = ""V[0]"",color = ""black""];"
"109->130 [label = ""V[0]"",color = ""black""];"
"110->122 [label = ""V[0]"",color = ""black""];"
"110->130 [label = ""V[0]"",color = ""black""];"
"111->122 [label = ""V[0]"",color = ""black""];"
"111->130 [label = ""V[0]"",color = ""black""];"
"112->122 [label = ""V[0]"",color = ""black""];"
"112->130 [label = ""V[0]"",color = ""black""];"
"113->122 [label = ""V[0]"",color = ""black""];"
"113->130 [label = ""V[0]"",color = ""black""];"
"114->122 [label = ""V[0]"",color = ""black""];"
"114->130 [label = ""V[0]"",color = ""black""];"
"115->122 [label = ""V[0]"",color = ""black""];"
"115->130 [label = ""V[0]"",color = ""black""];"
"115->135 [label = ""V[0]"",color = ""black""];"
"115->143 [label = ""V[0]"",color = ""black""];"
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment